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

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Aleksey Tsalolikhin <atsaloli(dot)tech(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: database response slows while pg_dump is running (8.4.2)
Date: 2010-06-11 01:01:48
Message-ID: 20100611010148.GM21875@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* Aleksey Tsalolikhin (atsaloli(dot)tech(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2010-06-11 01:12:15 Re: Enforcing password standards
Previous Message DM 2010-06-11 01:01:24 Enforcing password standards