On 2/27/07, D. Dante Lorenso <dante(at)lorenso(dot)com> wrote:
> Dann Corbit wrote:
> > If you only need a cardinality estimate, then pg_class.reltuples may be
> > of help (it will be accurate to when the last vacuum was performed).
> >
>
> Last vacuum ... how does that work with autovacuum?
'analyze' updates pg_class.reltuples also. It is also cheaper than
vacuum...you can force a fresh one by doing an analyze before you do
your sweep.
merlin