Re: Proposed patch: Smooth replication during VACUUM FULL - Mailing list pgsql-hackers

From Bernd Helmle
Subject Re: Proposed patch: Smooth replication during VACUUM FULL
Date
Msg-id 7C62CE31A631A0F98D4E62FD@apophis.local
Whole thread Raw
In response to Proposed patch: Smooth replication during VACUUM FULL  (Gabriele Bartolini <gabriele.bartolini@2ndQuadrant.it>)
Responses Re: Proposed patch: Smooth replication during VACUUM FULL  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers

--On 30. April 2011 20:19:36 +0200 Gabriele Bartolini 
<gabriele.bartolini@2ndQuadrant.it> wrote:

> I have noticed that during VACUUM FULL on reasonably big tables, replication
> lag climbs. In order to smooth down the replication lag, I propose the
> attached patch which enables vacuum delay for VACUUM FULL.

Hmm, but this will move one problem into another. You need to hold exclusive 
locks longer than necessary and given that we discourage the regular use of 
VACUUM FULL i cannot see a real benefit of it...

-- 
Thanks
Bernd



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: branching for 9.2devel
Next
From: Tom Lane
Date:
Subject: Re: Proposed patch: Smooth replication during VACUUM FULL