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 <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs