On May 1, 2015, at 9:16 AM, Susan K. McClure <smcclure@xxxxxxxx> wrote: > > The DB in question is ~25GB. The processor has 24 Cpus, 12 cores > > I have tried with "--jobs = 8, 12, and 20" with little or no discernible improvements. I would immediately suspect that you might be disk-bound instead of CPU-bound. What’s the setup of your storage system? -- Scott Ribe scott_ribe@xxxxxxxxxxxxxxxx http://www.elevated-dev.com/ https://www.linkedin.com/in/scottribe/ (303) 722-0567 voice -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin