Re: BUG #5932: CLUSTER doesn't update n_dead_tup - Mailing list pgsql-bugs

Andy Lester wrote:
>
> On Sep 6, 2011, at 9:04 AM, Bruce Momjian wrote:
>
> > Well, if you TRUNCATE I don't think it updates the statistics either.  I
> > think we assume the autovacuum system will analyse the new table soon.
>
>
> When I brought this up in IRC, I recall that that sentiment was
> expressed, along with the standard "What do you mean you're not running
> autovacuum?"

Well, if you are not running autovacuum you should be running vacuum and
analyze manually as needed.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +