Autovacuum and Autoanalyze
| От | Simon Riggs |
|---|---|
| Тема | Autovacuum and Autoanalyze |
| Дата | |
| Msg-id | 1221471987.3913.1244.camel@ebony.2ndQuadrant обсуждение исходный текст |
| Ответы |
Re: Autovacuum and Autoanalyze
Re: Autovacuum and Autoanalyze |
| Список | 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.comPostgreSQL Training, Services and Support
В списке pgsql-hackers по дате отправления: