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

Re: Indexing dead tuples

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: andrew(at)supernews(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Indexing dead tuples
Date: 2005-09-01 02:08:48
Message-ID: 7596.1125540528@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Simon Riggs <simon(at)2ndquadrant(dot)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

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2005-09-01 02:21:36
Subject: Re: Minimally avoiding Transaction Wraparound in VLDBs
Previous:From: Alvaro HerreraDate: 2005-09-01 01:48:04
Subject: Re: Minimally avoiding Transaction Wraparound in VLDBs

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