Skip site navigation (1) Skip section navigation (2)

Re: Proposed patch: Smooth replication during VACUUM FULL

From: Jaime Casanova <jaime(at)2ndquadrant(dot)com>
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 19:09:20
Message-ID: BANLkTimyte0OexNbMdRPnKFBRDhZKyByEg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Sat, Apr 30, 2011 at 1:19 PM, Gabriele Bartolini
<gabriele(dot)bartolini(at)2ndquadrant(dot)it> wrote:
> Hi guys,
>
> 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.
>

AFAICS, the problem is that those operations involve the rebuild of
tables, so we can't simply stop in the middle and wait because we will
need to hold a strong lock more time... also the patch seems to be
only doing something for CLUSTER and not for VACUUM FULL.
or am i missing something?

-- 
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte y capacitación de PostgreSQL

In response to

Responses

pgsql-hackers by date

Next:From: Joshua BerkusDate: 2011-04-30 19:23:29
Subject: Re: branching for 9.2devel
Previous:From: Kevin GrittnerDate: 2011-04-30 18:58:45
Subject: Large Objects versus transactional behavior

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group