On 11 Apr 2002, Bill Gribble wrote:
> On Wed, 2002-04-10 at 17:39, Gunther Schadow wrote:
>
> Then the biggest slowdown is count(*), which we have to do in order to
> fake up the scrollbar (so we know what proportion of the data has been
> scrolled through). I have not completely foxed this yet. I want to
> keep a separate mini-table of how many records are in the big table and
> update it with a trigger (the table is mostly static). ATM, I just try
> hard to minimize the times I call count(*).
Dont' recall right now which table, but there is a table that has record
counts. It is accurate if you have done a vacuum full. Vacuum analyze only
gives you estimates, but that may be good enough for your needs.