Re: Indexing dead tuples

From: Andrew - Supernews <andrew+nonews(at)supernews(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Indexing dead tuples
Date: 2005-08-31 22:31:53
Message-ID: slrndhcbup.1vfu.andrew+nonews@trinity.supernews.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2005-08-31, Simon Riggs <simon(at)2ndquadrant(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-08-31 23:06:25 Re: Indexing dead tuples
Previous Message Simon Riggs 2005-08-31 22:17:44 Minimally avoiding Transaction Wraparound in VLDBs