Re: database response slows while pg_dump is running (8.4.2) - Mailing list pgsql-general

From Aleksey Tsalolikhin
Subject Re: database response slows while pg_dump is running (8.4.2)
Date
Msg-id AANLkTineGPMKlAZnv8bwZISwDlJ0MOiBpfeiV1il8AEj@mail.gmail.com
Whole thread Raw
In response to Re: database response slows while pg_dump is running (8.4.2)  (Steve Crawford <scrawford@pinpointresearch.com>)
Responses Re: database response slows while pg_dump is running (8.4.2)
List pgsql-general
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

pgsql-general by date:

Previous
From: Steve Crawford
Date:
Subject: Re: database response slows while pg_dump is running (8.4.2)
Next
From: Alan Hodgson
Date:
Subject: Re: database response slows while pg_dump is running (8.4.2)