Re: [PERFORM] Postgres Dump - Creating index never stops

2017-07-12 Thread Tom Lane
Hans Braxmeier writes: > 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 the autovacuum task is running (almost) endless... > 2017-07-12 18:05:52.36

[PERFORM] Postgres Dump - Creating index never stops

2017-07-12 Thread Hans Braxmeier
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