Re: planner/optimizer question

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: "Gary Doades" <gpd(at)gpdnet(dot)co(dot)uk>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: planner/optimizer question
Date: 2004-04-28 07:34:59
Message-ID: j8nu80566omg3pne8bs1qtco2s8aeggnnq@email.aon.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, 28 Apr 2004 07:35:41 +0100, "Gary Doades" <gpd(at)gpdnet(dot)co(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Edoardo Ceccarelli 2004-04-28 08:13:14 Re: [JDBC] [PERFORM] is a good practice to create an index on the
Previous Message Christopher Kings-Lynne 2004-04-28 07:23:48 Re: planner/optimizer question