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