Re: Indexing dead tuples - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Indexing dead tuples
Date
Msg-id 7596.1125540528@sss.pgh.pa.us
Whole thread Raw
In response to Re: Indexing dead tuples  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:
> On Wed, 2005-08-31 at 19:06 -0400, Tom Lane wrote:
>> In fact, it had better be able to, since once the CREATE INDEX commits,
>> pre-existing xacts are responsible to insert index entries for anything
>> they insert into the table.

> So would it be possible to have CREATE INDEX call GetOldestXmin, just as
> VACUUM does, so it can work out which rows to ignore?

It already does.  See IndexBuildHeapScan().
        regards, tom lane


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Minimally avoiding Transaction Wraparound in VLDBs
Next
From: Tom Lane
Date:
Subject: Re: Minimally avoiding Transaction Wraparound in VLDBs