On Tue, Nov 1, 2011 at 8:07 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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
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.
The Enterprise PostgreSQL Company
In response to
pgsql-docs by date
|Next:||From: Scott Marlowe||Date: 2011-11-04 21:30:54|
|Subject: Re: docs update for count(*) and index-only scans|
|Previous:||From: Bruce Momjian||Date: 2011-11-04 16:32:13|
|Subject: Re: PGDATA confusion|