Re: Huge Data - Mailing list pgsql-general

From Sezai YILMAZ
Subject Re: Huge Data
Date
Msg-id 40054364.7020803@pro-g.com.tr
Whole thread Raw
In response to Re: Huge Data  (Shridhar Daithankar <shridhar_daithankar@myrealbox.com>)
Responses Re: Huge Data  (Franco Bruno Borghesi <franco@akyasociados.com.ar>)
Re: Huge Data  (Shridhar Daithankar <shridhar_daithankar@myrealbox.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Huge Data
Next
From:
Date:
Subject: Re: Using regular expressions in LIKE