Horton

Re: database response slows while pg_dump is running (8.4.2)

Steve Crawford <scrawford@pinpointresearch.com>

View thread View on postgr.es
From: Steve Crawford <scrawford@pinpointresearch.com>
To: Aleksey Tsalolikhin <atsaloli.tech@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Date: 2010-06-10T22:41:53Z
Lists: pgsql-general 
On 06/10/2010 02:49 PM, Aleksey Tsalolikhin wrote:
>    
> ...
>    
>> Is there any way I can keep my response fast but still get my pg_dump?
>>   Or should I move my pg_dump to a Slony-I slave?
>>      
>
> 1. We're not dumping across the network.  The pg_dump
> process runs on the same physical server as PostgreSQL.
>    
> ...
> 3. We ARE disk bound...

So are you writing the backup to the same disk(s) that support the db? 
What happens if you do the dump from a different machine? You'll 
increase network traffic, of course, but reduce your disk load. And you 
won't be keeping your dump on the same machine as your live data.

Cheers,
Steve