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@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
