Thanks!
We increased work memory from 16 MB to 32 MB and maintenance work memory
from 256 MB to 768 MB. That made a huge difference. We did set true the
log.statement and duration, but where is the file those are logging too?
That did the trick. 30 minutes only for a restrore instead of 5 + hours.
I did notice that the size is 4 GB instead of 5.6 GB. Is something else
going on?
We tried a pg_restore with -Fc once and only got 4 GB, but the next time
with a standard pg_dump command and psql newdb < dumpfile command, we also
had 4 GB.
~DjK
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
