On 2/27/07, D. Dante Lorenso <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
