| From: | Franco Bruno Borghesi <franco(at)akyasociados(dot)com(dot)ar> |
|---|---|
| To: | Sezai YILMAZ <sezai(dot)yilmaz(at)pro-g(dot)com(dot)tr> |
| Cc: | Shridhar Daithankar <shridhar_daithankar(at)myrealbox(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Huge Data |
| Date: | 2004-01-14 13:40:27 |
| Message-ID: | 1074087627.4082.2.camel@eddie.oficina |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sezai YILMAZ | 2004-01-14 13:45:05 | Re: Huge Data |
| Previous Message | terry | 2004-01-14 13:31:37 | Re: Using regular expressions in LIKE |