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-0004Jb-Mg@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
------
REL9_0_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/fb69fd176aaa8eab0315c4f891297c03c0b5d825

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