Re: More speed counting rows

On Mon, Jul 27, 2009 at 3:06 AM, Developer<dev002(at)pas-world(dot)com> wrote:
> 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?

Postgres cannot just use indexes, it has tot hit the tables. Rather
than suspecting what pgsql is doing, use explain analyze select ... to
see what your query is actually doing. If it is having to scan the
table each time, then faster IO or a different table layout may be in
order.