-
Notifications
You must be signed in to change notification settings - Fork 4
PostgreSQL
Rob Nagler edited this page May 12, 2018
·
2 revisions
We configure postgres in an include file in rsconf/postgresql.
We have found pg_restore --jobs=4
works reasonably well for a production database (bivio.com). There is no performance improvement with 8 jobs. We saw a 30% performance over two jobs. Going from one to two jobs, halves run-time.