Re: More speed counting rows

On Mon, Jul 27, 2009 at 5:06 AM, Developer wrote:
> Hello,
>
> I am trying to optimize the count of files when I am using filters
> (select by some row/s parameter/s)
> My question is:
> Any method for indirect count like ordered indexes + quadratic count?
> Any module?
> Any suggestion?

If all you need is a good-enough estimate, you can try reporting the
tuples count out of the stats tables. It'll only be as up-to-date as
autovac makes it, though. I do this in one app to give me ballpark
figures for some constantly-growing tables.


-- 
- David T. Wilson
david.t.wilson@gmail.com