From: Joshua D. Drake <jd@commandprompt.com>
To: girish R G peetle <giri.anamika0@gmail.com>
Cc: Eduardo Morras <emorrasg@yahoo.es>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: PostgreSQL Dump rate is too slow
Date: Thu, 15 Jan 2015 09:41:45 -0800
Message-ID: <54B7FBD9.7080404@commandprompt.com> (raw)
In-Reply-To: <CAKKd064A7+g8OA2vsn39643WWP74qoyC+XqxVrJtR55SbPLu4w@mail.gmail.com>
References: <CAKKd0663fQtOFMv-hWUDXrFecxmjeUW-=2PtkmTjxnaX-VsRRQ@mail.gmail.com>
<20150114212058.de1c87d91a851db0bce1f1fa@yahoo.es>
<54B6D972.8010304@commandprompt.com>
<CAKKd064A7+g8OA2vsn39643WWP74qoyC+XqxVrJtR55SbPLu4w@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On 01/15/2015 09:21 AM, girish R G peetle wrote:
> Hi all,
> We tried pg_dump with compression level set to zero on 1TB database.
> Dump data rate started with 250GB/hr and gradually dropped to 30 GB/hr
> with 2 hours time span. We might see this behavior on standby server
> too, which will be undesirable.
>
> Any explanation on why we see this behavior ?
Because you have a long running transaction that is causing bloat to
pile up. Using pg_dump on a production database that size is a
non-starter. You need a warm/hot standby or snapshot to do this properly.
JD
--
Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, @cmdpromptinc
"If we send our children to Caesar for their education, we should
not be surprised when they come back as Romans."
--
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: jd@commandprompt.com, giri.anamika0@gmail.com, emorrasg@yahoo.es
Subject: Re: PostgreSQL Dump rate is too slow
In-Reply-To: <54B7FBD9.7080404@commandprompt.com>
* 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