Re: More speed counting rows

Поиск
Список
Период
Сортировка
От Developer
Тема Re: More speed counting rows
Дата
Msg-id 1248721479.13431.9.camel@athlon.precioventa.com
обсуждение исходный текст
Ответ на Re: More speed counting rows  (Chris Ernst <cernst@esoft.com>)
Список pgsql-performance
> How "up to date" do the counts need to be?  If the count takes 4
> seconds, can you run it every minute and store the counts in a table for
> retrieval by the HTTP requests?
Now, I am storing integer value for filter in memory with timeout, but
in busy server, system sure crash without system memory (>700MB for all
combinations, if combinations counted > deleted memory count by
timeout).

> Or does it absolutely have to be the
> exact count at the moment of the request?
Some applications could fail, without exact number.



--














--
--
Publicidad y Servicios http://www.pas-world.com
Directorio http://www.precioventa.com
Tienda http://informatica.precioventa.com/es/
Autoridad certificadora http://ca.precioventa.com/es/
--
--


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

Предыдущее
От: Dave Youatt
Дата:
Сообщение: Re: hyperthreaded cpu still an issue in 8.4?
Следующее
От: Scott Carey
Дата:
Сообщение: Re: hyperthreaded cpu still an issue in 8.4?