PostgreSQL - radiasoft/devops GitHub Wiki

Stuff about Postgres

We configure postgres in an include file in rsconf/postgresql.

pg_restore --jobs=4

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.