Re: More speed counting rows

On Mon, Jul 27, 2009 at 5: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)
> 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(dot)t(dot)wilson(at)gmail(dot)com