[PERFORM] Postgres 9.5 / 9.6: Restoring PG 9.4 dump is very very slow

Hello, after updating my server to Postgres 9.5 (or 9.6) I tried to import PG 9.4 dumps and/or to restore 9.5/9.6 dumps: pg_dump testdb > db.sql psql -d testdb -f db.sql Restoring these dumps in PG 9.4 takes less than 20 minutes, restoring them in PG 9.5/9.5 takes several hours on the same sys

[PERFORM] Restoring Postgres Dump is very slow with Ubuntu 16.04

Hello, restoring a dump with Ubuntu 16.04 using postgres.conf default configuration (autovacuum on) takes several hours, with Ubuntu 14.04 only 20 minutes. Turning autovacuum off in Ubuntu 16.04 makes restoring much faster, with 14.04 autovacuum off has nearly no effect. The PG version does no

[PERFORM] Postgres uses too much RAM

Hello, on our old server (120 GB RAM) PostgreSQL 9.4.5 was using less than 10 GB of ram. On our new server (same system) Postgres 9.4.11 is using up to 40 GB Ram. Especially each idle process is consuming 2.4 GB: postgres 30764 8.3 2.4 3358400 3215920 ? Ss 21:58 0:24 postgres: testuser test

[PERFORM] Postgres Dump - Creating index never stops

Hello Experts, we have created a postgres dump using this command: pg_dump pixabay | gzip > pixabay.gz After restarting postgres (even with a new cluster) and creating a new database, postgres is hanging while extracting the dump: gunzip -c pixabay.gz | psql pixabay The log file shows that