Re: Proposed patch: Smooth replication during VACUUM FULL

From: Bernd Helmle <mailings(at)oopsware(dot)de>
To: Gabriele Bartolini <gabriele(dot)bartolini(at)2ndQuadrant(dot)it>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Proposed patch: Smooth replication during VACUUM FULL
Date: 2011-04-30 22:40:00
Message-ID: 7C62CE31A631A0F98D4E62FD@apophis.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

--On 30. April 2011 20:19:36 +0200 Gabriele Bartolini
<gabriele(dot)bartolini(at)2ndQuadrant(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-04-30 22:48:39 Re: Proposed patch: Smooth replication during VACUUM FULL
Previous Message Tom Lane 2011-04-30 21:33:33 Re: branching for 9.2devel