Re: Indexing dead tuples

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