Simon Riggs <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend