Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump and pg_restore with multiple streams does Not seem to improve overall times - Mailing list pgsql-admin

From Scott Ribe
Subject Re: pg_dump and pg_restore with multiple streams does Not seem to improve overall times
Date
Msg-id CF30A25D-6A2D-46B7-831F-D32C1478C882@elevated-dev.com
Whole thread Raw
In response to pg_dump and pg_restore with multiple streams does Not seem to improve overall times  ("Susan K. McClure" <smcclure@rice.edu>)
Responses Re: pg_dump and pg_restore with multiple streams does Not seem to improve overall times
List pgsql-admin
Tree view 
On May 1, 2015, at 9:16 AM, Susan K. McClure <smcclure@rice.edu> 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@elevated-dev.com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice

pgsql-admin by date:

Previous
From: "Susan K. McClure"
Date:
Subject: pg_dump and pg_restore with multiple streams does Not seem to improve overall times
Next
From: Scott Whitney
Date:
Subject: Re: pg_dump and pg_restore with multiple streams does Not seem to improve overall times