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 Lane||Date: 2005-09-01 02:21:36|
|Subject: Re: Minimally avoiding Transaction Wraparound in VLDBs |
|Previous:||From: Alvaro Herrera||Date: 2005-09-01 01:48:04|
|Subject: Re: Minimally avoiding Transaction Wraparound in VLDBs|