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.

In response to

• Re: Select max(foo) and select count(*) optimization at 2004-01-06 06:42:21 from Shridhar Daithankar

pgsql-performance by date

Next:	From: D'Arcy J.M. Cain	Date: 2004-01-06 12:18:08
	Subject: Re: Select max(foo) and select count(*) optimization
Previous:	From: Shridhar Daithankar	Date: 2004-01-06 06:42:21
	Subject: Re: Select max(foo) and select count(*) optimization