On Wed, 28 Apr 2004 07:35:41 +0100, "Gary Doades" <gpd(at)gpdnet(dot)co(dot)uk>
>Why is there an entry in the index for a row if the row is not valid?
Because whether a row is seen as valid or not lies in the eye of the
transaction looking at it. Full visibility information is stored in the
heap tuple header. The developers' consensus is that this overhead
should not be in every index tuple.
In response to
pgsql-performance by date
|Next:||From: Edoardo Ceccarelli||Date: 2004-04-28 08:13:14|
|Subject: Re: [JDBC] [PERFORM] is a good practice to create an index on the|
|Previous:||From: Christopher Kings-Lynne||Date: 2004-04-28 07:23:48|
|Subject: Re: planner/optimizer question|