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
In response to
pgsql-general by date
|Next:||From: Tom Lane||Date: 2007-02-27 02:25:01|
|Subject: Re: preventing ALTER TABLE RENAME from changing view definitions? |
|Previous:||From: George Nychis||Date: 2007-02-27 01:48:35|
|Subject: Re: dropping a master table and all of its partitions?|