Date: Thu, 8 Jan 2015 15:03:52 -0300
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: "ktm@rice.edu" <ktm@rice.edu>
Cc: David G Johnston <david.g.johnston@gmail.com>, pgsql-admin@postgresql.org
Subject: Re: PostgreSQL Dump rate is too slow
Message-ID: <20150108180352.GB1479@alvh.no-ip.org>
References: 
 <CAKKd0663fQtOFMv-hWUDXrFecxmjeUW-=2PtkmTjxnaX-VsRRQ@mail.gmail.com>
 <CANnQH_i5k+Rq9ntcu1DiggfTcGUZ=eXmMFc0ptTjPHkxN_U16A@mail.gmail.com>
 <CAKFQuwaCwXdkO_4a6-SsxX-_MOBNnZZQQF41R-YWphN5MwFkqA@mail.gmail.com>
 <20150108154404.GH3783@aart.rice.edu>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <20150108154404.GH3783@aart.rice.edu>
User-Agent: Mutt/1.5.23 (2014-03-12)
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

ktm@rice.edu wrote:
> 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.
> 
> 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.

Keep in mind, though, that while 9.3's pg_dump can read from a 9.2
server, there is no guarantee that what it writes will be readable by
9.2 other tools (pg_restore or psql).  Maybe it is currently, but there
are no promises.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin