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

From: Greg Smith <greg(at)2ndquadrant(dot)com>
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-10 21:23:58
Message-ID: 4C1157EE.9090205@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)2ndQuadrant(dot)com www.2ndQuadrant.us

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Atkins 2010-06-10 21:26:25 Re: Best way to store case-insensitive data?
Previous Message Andy Colson 2010-06-10 21:22:04 Re: database response slows while pg_dump is running (8.4.2)