X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 21FF7D1B8AA for ; Wed, 28 Apr 2004 10:05:06 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 42082-07 for ; Wed, 28 Apr 2004 10:05:08 -0300 (ADT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 1EA39D1B893 for ; Wed, 28 Apr 2004 10:05:04 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i3SD54l0027807; Wed, 28 Apr 2004 09:05:04 -0400 (EDT) To: Manfred Koizar Cc: "Gary Doades" , pgsql-performance@postgresql.org Subject: Re: planner/optimizer question In-reply-to: References: <20040426171103.45600.qmail@uno.mnl.com> <23032.1083126479@sss.pgh.pa.us> <408F5ECD.29849.CA91084@localhost> Comments: In-reply-to Manfred Koizar message dated "Wed, 28 Apr 2004 09:34:59 +0200" Date: Wed, 28 Apr 2004 09:05:04 -0400 Message-ID: <27806.1083157504@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200404/485 X-Sequence-Number: 6785 Manfred Koizar writes: > On Wed, 28 Apr 2004 07:35:41 +0100, "Gary Doades" > 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. Storing that information would at least double the overhead space used for each index tuple. The resulting index bloat would significantly slow index operations by requiring more I/O. So it's far from clear that this would be a win, even for those who care only about select speed. regards, tom lane