On Tue, Nov 1, 2011 at 8:07 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> It's the "lobotomized engines" that are the problem, IMO --- people
> coming from databases like mysql tend to think count(*) just means
> reading a table size counter that the engine has anyway.
This is probably a much less common misconception than formerly, due
to the rise of InnoDB and the falling-out-of-favor experienced by
MyISAM.
I think some pessimism removal is probably warranted. Yeah, somebody
else might be faster than us on this test, but that's probably true of
many tests. And on others we will be faster than them.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company