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.
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 ?
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.
Don't do this. You are still looking at an extremely slow dump. Instead set up a warm or hot standby or use pg_basebackup.
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."