From: Eduardo Morras <emorrasg@yahoo.es>
To: pgsql-admin@postgresql.org
Subject: Re: PostgreSQL Dump rate is too slow
Date: Wed, 14 Jan 2015 21:20:58 +0100
Message-ID: <20150114212058.de1c87d91a851db0bce1f1fa@yahoo.es> (raw)
In-Reply-To: <CAKKd0663fQtOFMv-hWUDXrFecxmjeUW-=2PtkmTjxnaX-VsRRQ@mail.gmail.com>
References: <CAKKd0663fQtOFMv-hWUDXrFecxmjeUW-=2PtkmTjxnaX-VsRRQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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
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: emorrasg@yahoo.es
Subject: Re: PostgreSQL Dump rate is too slow
In-Reply-To: <20150114212058.de1c87d91a851db0bce1f1fa@yahoo.es>
* 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