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

pgsql: Make CLUSTER lock the old table's toast table before copyingdat

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Make CLUSTER lock the old table's toast table before copyingdat
Date: 2011-05-01 21:58:17
Message-ID: E1QGeef-0004JZ-Mm@gemulon.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Make CLUSTER lock the old table's toast table before copying data.

We must lock out autovacuuming of the old toast table before computing the
OldestXmin horizon we will use.  Otherwise, autovacuum could start on the
toast table later, compute a later OldestXmin horizon, and remove as DEAD
toast tuples that we still need (because we think their parent tuples are
only RECENTLY_DEAD).  Per further thought about bug #5998.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/83b7584944b3a9df064cccac06822093f1a83793

Modified Files
--------------
src/backend/commands/cluster.c |   17 +++++++++++++++++
1 files changed, 17 insertions(+), 0 deletions(-)

pgsql-committers by date

Next:From: Peter EisentrautDate: 2011-05-01 22:06:31
Subject: pgsql: Catch errors in for loop in makefile
Previous:From: Dave PageDate: 2011-05-01 09:15:51
Subject: Re: pgsql: Fix pg_size_pretty() to avoid overflow for inputs close to INT64

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