Date: Wed, 14 Jan 2015 21:20:58 +0100
From: Eduardo Morras <emorrasg@yahoo.es>
To: pgsql-admin@postgresql.org
Subject: Re: PostgreSQL Dump rate is too slow
Message-Id: <20150114212058.de1c87d91a851db0bce1f1fa@yahoo.es>
In-Reply-To: 
 <CAKKd0663fQtOFMv-hWUDXrFecxmjeUW-=2PtkmTjxnaX-VsRRQ@mail.gmail.com>
References: 
 <CAKKd0663fQtOFMv-hWUDXrFecxmjeUW-=2PtkmTjxnaX-VsRRQ@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

On Thu, 8 Jan 2015 11:05:54 +0530
girish R G peetle <giri.anamika0@gmail.com> wrote:

> Hi all,
> We have a customer who has 1TB database on a production server. They
> are trying dump based backup of this large database. Following dump
> command is being used.
> Dump rate is around 12 GB/hr, which will take lot of time for the
> backup to complete. This is affecting their production server.
> Is there is a way to increase dump data rate ?
> 
> pg_dump -U <User> -Fc -b --port=<Port> '<Db-Name>'
> 

Do not use pg_dump compression, pipe output to xz

% pg_dump -U <User> -Fc -b --port=<Port> '<Db-Name>' | xz -3 dump.xz 

or pipe xz output to other program.

When I looked for the same problem in 8.3-8.4 versions, the bottleneck was in accessing TOAST tables, it's content was decompressed, dumped and recompressed again, don't know if it has changed in current versions.

> 
> PostgreSQL version : 9.2.4
> Platform : Linux
> 
> Thanks
> Girish


---   ---
Eduardo Morras <emorrasg@yahoo.es>


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