| From: | Developer <dev002(at)pas-world(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | More speed counting rows |
| Date: | 2009-07-27 09:06:41 |
| Message-ID: | 1248685601.13528.17.camel@athlon.precioventa.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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/
--
--
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eric Comeau | 2009-07-27 10:43:07 | Re: Very big insert/join performance problem (bacula) |
| Previous Message | Alvaro Herrera | 2009-07-27 02:00:19 | Re: Postgres user authentification or LDAP authentification |