Skip site navigation (1) Skip section navigation (2)

More speed counting rows

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 (view raw or flat)
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/
--
--


Responses

pgsql-performance by date

Next:From: Eric ComeauDate: 2009-07-27 10:43:07
Subject: Re: Very big insert/join performance problem (bacula)
Previous:From: Alvaro HerreraDate: 2009-07-27 02:00:19
Subject: Re: Postgres user authentification or LDAP authentification

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group