Re: PostgreSQL Dump rate is too slow - Mailing list pgsql-admin

From Jeff Frost
Subject Re: PostgreSQL Dump rate is too slow
Date
Msg-id 1C4DCFE6-E0B2-4EF4-8A62-653B960054B4@pgexperts.com
Whole thread Raw
In response to PostgreSQL Dump rate is too slow  (girish R G peetle <giri.anamika0@gmail.com>)
Responses Re: PostgreSQL Dump rate is too slow  (girish R G peetle <giri.anamika0@gmail.com>)
List pgsql-admin
> On Jan 7, 2015, at 21:35, 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
productionserver.   
> 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
dumpfile.   

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.

pgsql-admin by date:

Previous
From: David G Johnston
Date:
Subject: Re: PostgreSQL Dump rate is too slow
Next
From: girish R G peetle
Date:
Subject: Re: PostgreSQL Dump rate is too slow