Re: Most efficient report of number of records in all tables?

On 2/27/07, D. Dante Lorenso <dante@lorenso.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