Top "Postgresql-9.6" questions

How to connect Odoo with postgres (which is running on other server)

I want to connect odoo 10 with the postgresql (which is running on other server). Is it possible ? If, yes! then …

postgresql python-2.7 python-3.x odoo-10 postgresql-9.6

How to use an array as a variable in Postgres?

I have this .sql script: DO $$ DECLARE user_list integer[] = (select user_id from user where state = 'ACTIVE'); BEGIN CREATE …

postgresql postgresql-9.6

Autovacuum of a large table takes too long

I upgraded my 9.4 postgresql cluster to 9.6. (via pg_upgrade, so my db stats were not moved to a new cluster) …

postgresql postgresql-9.6 autovacuum

Slow nested loop left join with index scan 130k times in loop

I am really struggling to optimize this query: SELECT wins / (wins + COUNT(loosers.match_id) + 0.) winrate, wins + COUNT(loosers.match_…

postgresql indexing database-performance postgresql-performance postgresql-9.6

PostgreSql : ERROR: relation "sequence" does not exist while restoring from dump file

I get the following error while restoring database from dump file on server: ERROR: relation "table_id_seq" does not …

postgresql postgresql-9.6 pg-dump postgresql-10

Postgresql | remaining connection slots are reserved for non-replication superuser connections

I am getting an error "remaining connection slots are reserved for non-replication superuser connections" at one of PostgreSQL instances. However, …

postgresql postgresql-9.6

How to use PostgreSQL JSONB_SET() to create new deep object element

I must be missing something... seems JSONB_SET() is not working as advertised? SELECT JSONB_SET( '{"k1": {"value": "v1"}}…

postgresql jsonb postgresql-9.6

Postgres 9.6: Parallel query does not take max_parallel_workers_per_gather setting

Postgres 9.6; Centos 6.7 ; 24 cores BigTable1 contains 1,500,000,000 rows; weight 180GB. max_worker_processes = 20 max_parallel_workers_per_gather = 12 1) When running EXPLAIN SELECT …

postgresql parallel-processing explain postgresql-9.6