On Sat, Apr 30, 2011 at 1:19 PM, Gabriele Bartolini
> 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
pgsql-hackers by date
|Next:||From: Joshua Berkus||Date: 2011-04-30 19:23:29|
|Subject: Re: branching for 9.2devel|
|Previous:||From: Kevin Grittner||Date: 2011-04-30 18:58:45|
|Subject: Large Objects versus transactional behavior|