| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Autovacuum and Autoanalyze |
| Date: | 2008-09-15 09:46:27 |
| Message-ID: | 1221471987.3913.1244.camel@ebony.2ndQuadrant |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Disabling autovacuum can have catastrophic effects, since it disables
the ANALYZing of tables.
Can we have a mode where we disable autoVACUUM yet enable autoANALYZE?
ANALYZE times are fairly bounded because of the way we do sampling.
VACUUM times are not bounded at all, and typically > O(n). So it makes
sense to switch off the VACUUM at certain times, but never good to
switch off ANALYZE.
While we're there, it would be useful if CREATE TABLE AS SELECT was
followed by an automatic ANALYZE. Especially important for temp tables.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory Stark | 2008-09-15 09:47:35 | Re: rmgr hooks and contrib/rmgr_hook |
| Previous Message | Tatsuo Ishii | 2008-09-15 09:46:16 | Re: Common Table Expressions (WITH RECURSIVE) patch |