On Thu, Jun 10, 2010 at 3:41 PM, Steve Crawford
<scrawford(at)pinpointresearch(dot)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