More speed counting rows - Mailing list pgsql-performance

From Developer
Subject More speed counting rows
Date
Msg-id 1248685601.13528.17.camel@athlon.precioventa.com
Whole thread Raw
Responses 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>)
List 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [BUGS] Postgres user authentification or LDAP authentification
Next
From: Robert Haas
Date:
Subject: Re: Can Postgres use an INDEX over an OR?