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

From Stephen Frost
Subject Re: database response slows while pg_dump is running (8.4.2)
Date
Msg-id 20100611010148.GM21875@tamriel.snowman.net
Whole thread Raw
In response to Re: database response slows while pg_dump is running (8.4.2)  (Aleksey Tsalolikhin <atsaloli.tech@gmail.com>)
List pgsql-general
* Aleksey Tsalolikhin (atsaloli.tech@gmail.com) wrote:
> I am moving the pg_dump process to a Slony slave.

Good idea.

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

You could maybe try ionice'ing the PG process that is the pg_dump
connection...  Identifying which one that is would be slightly tricky,
but not all *that* difficult.  Don't know if you really want to go there
tho.

    Thanks,

        Stephen

Attachment

pgsql-general by date:

Previous
From: DM
Date:
Subject: Enforcing password standards
Next
From: Scott Marlowe
Date:
Subject: Re: Enforcing password standards