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

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: database response slows while pg_dump is running (8.4.2)
Date: 2010-06-10 23:00:58
Message-ID: 201006101600.58545@hal.medialogik.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thursday, June 10, 2010, Aleksey Tsalolikhin <atsaloli(dot)tech(at)gmail(dot)com>
wrote:
> Thanks anyway - glad to hear dumping from a slave is
> a popular approach, that's what we'll do. This is good,
> it'll allow us to increase our pg_dumps from 1 a day to
> as many as we want to feel safe.

You should look into PITR backups. You can keep a very current running
backup with little overhead.

--
"No animals were harmed in the recording of this episode. We tried but that
damn monkey was just too fast."

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John T. Dow 2010-06-11 00:06:40 Re: Re: Error on Windows server could not open relation base/xxx/xxx Permission denied
Previous Message J. Greg Davidson 2010-06-10 22:59:48 Can ARRAY( ... ) generate text[][]?