Re: Huge Data

Поиск
Список
Период
Сортировка
От Shridhar Daithankar
Тема Re: Huge Data
Дата
Msg-id 200401141920.33017.shridhar_daithankar@myrealbox.com
обсуждение исходный текст
Ответ на Re: Huge Data  (Sezai YILMAZ <sezai.yilmaz@pro-g.com.tr>)
Список pgsql-general
On Wednesday 14 January 2004 18:55, 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.

Well, you could document it somewhere for your reference. It is not that
hard..:-)

And remember, the value you get is just an estimate. You need to analyze the
table often with respect to it's update/insert/delete activity to keep the
estimate reasonable accurate. Vacuuming would also update the estimate.

 Shridhar


В списке pgsql-general по дате отправления:

Предыдущее
От: "Nick Barr"
Дата:
Сообщение: Re: Using regular expressions in LIKE
Следующее
От: "Sander Steffann"
Дата:
Сообщение: Re: 7.4.1 packages for RHEL2.1