Re: Huge Data

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