Re: Huge Data

If the mentioned solution fits your needs, you could create a stored procedure using that. The postgreSQL implementation could select from pg_class, while the same function in other database could execute the select count() on the table.

On Wed, 2004-01-14 at 10:25, Sezai YILMAZ wrote:

Shridhar Daithankar wrote:

>Rather than doing count(*), you should either cache the count in application 
>memory
>
> or analyze often and use following.
>
>'select reltuples from pg_class where relname = 'foo';
>
Thank you very much Shridhar. This one is responsive immediately. I 
think I will use this method for gathering row count. But I complain to 
break SQL standards. The code will become unmovable.

-sezai

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
              http://archives.postgresql.org