Indexing dead tuples - Mailing list pgsql-hackers

From Simon Riggs
Subject Indexing dead tuples
Date
Msg-id 1125523531.3956.15.camel@localhost.localdomain
Whole thread Raw
List pgsql-hackers
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, so there is no danger
that it can use the index and unknowingly avoid touching a valid row.
(If it *can* see the index, is there some benefit in that behaviour?)

I suggest that we should not include dead rows in an index when it is
created, to increase the speed of index creation in certain cases. This
also simplifies a number of the index build routines, which actually
contain special logic for handling dead rows.

Comments?

Best Regards, Simon Riggs




pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: 8.1 and syntax checking at create time
Next
From: Tom Lane
Date:
Subject: Procedural language definitions (was Re: 8.1 and syntax checking at create time)