Cea Stapleton <[email protected]> writes:
> Weâre using pg_restore (PostgreSQL) 9.5.4 for the restores. Weâve used
> variations on the job number:
> /usr/bin/pg_restore -j 6 -Fc -O -c -d DBNAME RESTORE_FILEâ
OK ... do you actually need the -c, and if so why?
> Weâll take a look at the memory overcommit - would that also explain the
> index issues we were seeing before we were seeing the crashes?
Unlikely. I'm guessing that there's some sort of race condition involved
in parallel restore with -c, but it's not very clear what.
regards, tom lane
--
Sent via pgsql-performance mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
