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