pgsql: Make CLUSTER lock the old table's toast table before copying dat - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Make CLUSTER lock the old table's toast table before copying dat
Date
Msg-id E1QGeef-0004JZ-Mm@gemulon.postgresql.org
Whole thread Raw
List 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:

Previous
From: Dave Page
Date:
Subject: Re: pgsql: Fix pg_size_pretty() to avoid overflow for inputs close to INT64
Next
From: Tom Lane
Date:
Subject: pgsql: Make CLUSTER lock the old table's toast table before copying dat