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

On Thu, Jun 10, 2010 at 3:41 PM, Steve Crawford
<scrawford@pinpointresearch.com> wrote:
> 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.

Good point.  I tried that, actually, but was still disk-bound.
(Mostly read activity.)

I am moving the pg_dump process to a Slony slave.

Thanks!
Aleksey