From: ktm@rice.edu <ktm@rice.edu>
To: David G Johnston <david.g.johnston@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: PostgreSQL Dump rate is too slow
Date: Thu, 8 Jan 2015 09:44:04 -0600
Message-ID: <20150108154404.GH3783@aart.rice.edu> (raw)
In-Reply-To: <CAKFQuwaCwXdkO_4a6-SsxX-_MOBNnZZQQF41R-YWphN5MwFkqA@mail.gmail.com>
References: <CAKKd0663fQtOFMv-hWUDXrFecxmjeUW-=2PtkmTjxnaX-VsRRQ@mail.gmail.com>
<CANnQH_i5k+Rq9ntcu1DiggfTcGUZ=eXmMFc0ptTjPHkxN_U16A@mail.gmail.com>
<CAKFQuwaCwXdkO_4a6-SsxX-_MOBNnZZQQF41R-YWphN5MwFkqA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On Thu, Jan 08, 2015 at 08:38:37AM -0700, David G Johnston wrote:
> On Thu, Jan 8, 2015 at 12:12 AM, Adalkonda Harshad [via PostgreSQL] <
> ml-node+s1045698n5833283h97@n5.nabble.com> wrote:
>
> >
> > As the database size is too large and tweaking few database parameters
> > will result towards performance improvement on pg_dump to some extent and
> > pg_dump -j option would have helped if the DB version is PostgreSQL 9.3 but
> > unfortunately your DB version is PostgreSQL 9.2
> >
> >
> pg_dump 9.3+ can be used against the 9.2 server without problems. Read
> the documentation for the --jobs option for details.
>
> David J.
>
>
+1
This is a nice option for allowing you to leverage more than a single CPU core
for the dump, provided you have the CPU and I/O cycles to support it. As others
have suggested, offloading to a replica can help with that.
Regards,
Ken
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ktm@rice.edu, david.g.johnston@gmail.com
Subject: Re: PostgreSQL Dump rate is too slow
In-Reply-To: <20150108154404.GH3783@aart.rice.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox