Horton

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

Greg Smith <greg@2ndquadrant.com>

View thread View on postgr.es
From: Greg Smith <greg@2ndquadrant.com>
To: Aleksey Tsalolikhin <atsaloli.tech@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Date: 2010-06-10T21:23:58Z
Lists: pgsql-general 
Aleksey Tsalolikhin wrote:
> Is there any way I can keep my response fast but still get my pg_dump?
>   

http://wiki.postgresql.org/wiki/Priorities covers the usual techniques 
you might use to slow down your pg_dump to where it doesn't impact the 
main server as much.

> Or should I move my pg_dump to a Slony-I slave?
>   

Dumping from a slave is also a popular approach worth considering.

-- 
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com   www.2ndQuadrant.us