Horton

Re: Proposed patch: Smooth replication during VACUUM FULL

Bernd Helmle <mailings@oopsware.de>

View thread
From: Bernd Helmle <mailings@oopsware.de>
To: Gabriele Bartolini <gabriele.bartolini@2ndQuadrant.it>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2011-04-30T22:40:00Z
Lists: 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