Re: pg_dump and pg_restore with multiple streams does Not seem to improve overall times

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: "Susan K(dot) McClure" <smcclure(at)rice(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dump and pg_restore with multiple streams does Not seem to improve overall times
Date: 2015-05-01 15:22:11
Message-ID: CF30A25D-6A2D-46B7-831F-D32C1478C882@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On May 1, 2015, at 9:16 AM, Susan K. McClure <smcclure(at)rice(dot)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(at)elevated-dev(dot)com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Whitney 2015-05-01 15:29:33 Re: pg_dump and pg_restore with multiple streams does Not seem to improve overall times
Previous Message Susan K. McClure 2015-05-01 15:16:21 pg_dump and pg_restore with multiple streams does Not seem to improve overall times