Re: Autovacuum on by default?
От | Peter Eisentraut |
---|---|
Тема | Re: Autovacuum on by default? |
Дата | |
Msg-id | 200608251130.46372.peter_e@gmx.net обсуждение исходный текст |
Ответ на | Autovacuum on by default? (Peter Eisentraut <peter_e@gmx.net>) |
Ответы |
Re: Autovacuum on by default?
Re: Autovacuum on by default? |
Список | pgsql-hackers |
Summarizing this thread, I see support for the following: - autovacuum set to on by default in 8.2. - stats_row_level also defaults to on. (Perhaps stats_block_level should also default to on so it's not inconsistent, seeing that everything else in on, too.) - Delayed vacuum and delayed autovacuum will stay disabled. - Scale factor set to 0.08 (vacuum) and 0.04 (analyze) (?) (formerly 0.4 and 0.2) - Leave base thresholds alone (pending further analysis that might remove them altogether?) -- Peter Eisentraut http://developer.postgresql.org/~petere/
В списке pgsql-hackers по дате отправления: