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@xxxxxxxxxxxxxxx www.2ndQuadrant.us -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
