Re: Select max(foo) and select count(*) optimization

Hi,

Shridhar Daithankar wrote:

>
> select relpages,reltuples from pg_class where relname=<tablename>;
>
> Assuming the stats are recent enough, it would be much faster and accurate..

this needs an analyze <tablename>; before select from pg_class, cause
only after analyze will update pg the pg_class

C.