X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id F21B1D1B520 for ; Sat, 4 Oct 2003 21:16:23 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 85703-10 for ; Sat, 4 Oct 2003 18:15:40 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id A2E98D1B53F for ; Sat, 4 Oct 2003 18:15:37 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id h94LFOhn022014; Sat, 4 Oct 2003 17:15:24 -0400 (EDT) To: Hannu Krosing Cc: Christopher Browne , pgsql-performance@postgresql.org, "pgsql-hackers@postgresql.org" Subject: Re: COUNT(*) again (was Re: [HACKERS] Index/Function organized table layout) In-reply-to: <1065301140.2746.37.camel@fuji.krosing.net> References: <20031002191547.GZ87525@rlx11.zapatec.com> <20031002193905.GD18417@wolff.to> <3F7C98B8.C892D0E5@nsd.ca> <60brszcng5.fsf@dev6.int.libertyrms.info> <1065258004.2746.30.camel@fuji.krosing.net> <6102.1065283673@sss.pgh.pa.us> <1065301140.2746.37.camel@fuji.krosing.net> Comments: In-reply-to Hannu Krosing message dated "Sat, 04 Oct 2003 23:59:00 +0300" Date: Sat, 04 Oct 2003 17:15:24 -0400 Message-ID: <22013.1065302124@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/147 X-Sequence-Number: 3895 Hannu Krosing writes: > The point I was trying to make was that faster count(*)'s is just a side > effect. If we could (conditionally) keep visibility info in indexes, I think that's not happening, conditionally or otherwise. The atomicity problems alone are sufficient reason why not, even before you look at the performance issues. regards, tom lane