Cea Stapleton 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 - w
Thanks Tom!
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”
We’ll take a look at the memory overcommit - would that also explain the index
issues we were seeing before we were seeing
Cea Stapleton writes:
> We are having a baffling problem we hope you might be able to help with. We
> were hoping to speed up postgres restores to our reporting server. First, we
> were seeing missing indexes with pg_restore to our reporting server for one
> of our databases when we did pg_rest
