Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group