Horton

Re: COUNT(*) again (was Re: [HACKERS] Index/Function organized table layout)

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Hannu Krosing <hannu@tm.ee>
Cc: Christopher Browne <cbbrowne@libertyrms.info>, pgsql-performance@postgresql.org, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2003-10-04T21:15:24Z
Lists: pgsql-hackers, pgsql-performance 
Hannu Krosing <hannu@tm.ee> 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