Re: Indexing dead tuples - Mailing list pgsql-hackers

From Andrew - Supernews
Subject Re: Indexing dead tuples
Date
Msg-id slrndhcbup.1vfu.andrew+nonews@trinity.supernews.net
Whole thread Raw
In response to Indexing dead tuples  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Indexing dead tuples  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 2005-08-31, Simon Riggs <simon@2ndquadrant.com> wrote:
> During CREATE INDEX we include all tuples, even if they are already dead
> when we build an index.
>
> What purpose does this serve?
>
> A pre-existing transaction can't see the index,

Yes, it can; the catalog is read in SnapshotNow rather than in the query
snapshot.

-- 
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Minimally avoiding Transaction Wraparound in VLDBs
Next
From: Tom Lane
Date:
Subject: Re: Indexing dead tuples