More speed counting rows

Поиск
Список
Период
Сортировка
От Developer
Тема More speed counting rows
Дата
Msg-id 1248685601.13528.17.camel@athlon.precioventa.com
обсуждение исходный текст
Ответы Re: More speed counting rows  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: More speed counting rows  (Chris Ernst <cernst@esoft.com>)
Re: More speed counting rows  (David Wilson <david.t.wilson@gmail.com>)
Список pgsql-performance
Hello,

I am trying to optimize the count of files when I am using filters
(select by some row/s parameter/s)

In this case I think that postgresql really count all files.
Resulting in unacceptable times of 4 seconds in http server response.
Triggers+store in this case do not see very acceptable, because I need
store 1.5 millions of counting possibilities.

My question is:
Any method for indirect count like ordered indexes + quadratic count?
Any module?
Any suggestion?

--














--
--
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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: [BUGS] Postgres user authentification or LDAP authentification
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Can Postgres use an INDEX over an OR?