Re: Berserk Autovacuum (let's save next Mandrill)
От | Alvaro Herrera |
---|---|
Тема | Re: Berserk Autovacuum (let's save next Mandrill) |
Дата | |
Msg-id | 20190410151306.GA26795@alvherre.pgsql обсуждение исходный текст |
Ответ на | Re: Berserk Autovacuum (let's save next Mandrill) (Darafei "Komяpa" Praliaskouski <me@komzpa.net>) |
Ответы |
Re: Berserk Autovacuum (let's save next Mandrill)
Re: Berserk Autovacuum (let's save next Mandrill) |
Список | pgsql-hackers |
On 2019-Mar-31, Darafei "Komяpa" Praliaskouski wrote: > Alternative point of "if your database is super large and actively written, > you may want to set autovacuum_freeze_max_age to even smaller values so > that autovacuum load is more evenly spread over time" may be needed. I don't think it's helpful to force emergency vacuuming more frequently; quite the contrary, it's likely to cause even more issues. We should tweak autovacuum to perform freezing more preemtively instead. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
В списке pgsql-hackers по дате отправления: