Re: [HACKERS] Slow count(*) again...

Mladen Gogala <mladen.gogala@vmsinfo.com>

From: Mladen Gogala <mladen.gogala@vmsinfo.com>

To: Andrew Dunstan <andrew@dunslane.net>

Cc: Bruce Momjian <bruce@momjian.us>, Tom Lane <tgl@sss.pgh.pa.us>, "david@lang.hm" <david@lang.hm>, Craig Ringer <craig@postnewspapers.com.au>, Vitalii Tymchyshyn <tivv00@gmail.com>, "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>

Date: 2011-02-01T23:44:17Z

Lists: pgsql-hackers, pgsql-performance

On 2/1/2011 6:03 PM, Andrew Dunstan wrote:
> Whether or not it's bad application design, it's ubiquitous, and we
> should make it work as best we can, IMNSHO. This often generates
> complaints about Postgres, and if we really plan for world domination
> this needs to be part of it.

There are many other things to fix first. One of them would be optimizer 
decisions when a temp table is involved. I would also vote for wait 
event interface, tracing and hints, much rather than speeding up 
count(*). World domination will not be achieved by speeding up count(*), 
it will be achieved by providing overall performance akin to what the 
player who has already achieved the world domination. I believe that the 
company is called "Oracle Corp." or something like that?

-- 

Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
http://www.vmsinfo.com
The Leader in Integrated Media Intelligence Solutions