> The optimizer is perfectly happy with approximate tuple counts, so it
> makes do with stats recorded at the last VACUUM.
> 
> This has been discussed quite recently on pg-hackers; see the archives
> for more info.

Yes, the problem is not the optimizer. The problem is the select count(*).
A lot of DB's (like Informix) have a shortcut on this, and even though they
have it,
they don't use it for the optimizer.

If our btrees have an accurate count (deleted rows ?), scanning the smallest
index 
would also be alot faster.

Andreas

Fri, 29 Oct 1999 11:34:44 +0200
Zeugswetter Andreas IZ5 <ZeugswetterA@wien.spardat.at>
AW: [HACKERS] Bug#48582: psql spends hours computing results it a
	lready knows (fwd)