Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] COUNT(*) again (was Re: Index/Function organized table layout) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PERFORM] COUNT(*) again (was Re: Index/Function organized table layout)
Date
Msg-id 22013.1065302124@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PERFORM] COUNT(*) again (was Re: Index/Function  (Hannu Krosing <hannu@tm.ee>)
Responses Re: [PERFORM] COUNT(*) again (was Re: Index/Function organized  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: max_connections/shared_buffers (was Re: Beta4 Tag'd and Bundled ...)
Next
From: James Rogers
Date:
Subject: Uses for Index/Function organizing