Re: PostgreSQL Dump rate is too slow

> On Jan 7, 2015, at 21:35, girish R G peetle <giri(dot)anamika0(at)gmail(dot)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>'
>

You could reduce the compression ratio. Gzip defaults to -Z6, but -Z3 is quite a bit quicker with not that much larger dump file.

I did a few tests here: http://frosty-postgres.blogspot.com/2011/12/pgdump-compression-settings.html

Also, if it's is impacting production, you could set up a streaming replica and take the dump from the replica.