Re: planner/optimizer question - Mailing list pgsql-performance

From Manfred Koizar
Subject Re: planner/optimizer question
Date
Msg-id j8nu80566omg3pne8bs1qtco2s8aeggnnq@email.aon.at
Whole thread Raw
In response to Re: planner/optimizer question  ("Gary Doades" <gpd@gpdnet.co.uk>)
Responses Re: planner/optimizer question
List pgsql-performance
On Wed, 28 Apr 2004 07:35:41 +0100, "Gary Doades" <gpd@gpdnet.co.uk>
wrote:
>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.

Servus
 Manfred

pgsql-performance by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: planner/optimizer question
Next
From: Suller András
Date:
Subject: Re: Join problem