Re: PostgreSQL 11 Auto vacuum

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: PostgreSQL 11 Auto vacuum
Дата
Msg-id CAHOFxGrFzT+gShBzFmoyg-tmEj8ps8m4SO=TPo0h0sufPJqznA@mail.gmail.com
обсуждение исходный текст
Ответ на PostgreSQL 11 Auto vacuum  (Pawan Sharma <pawanpg0963@gmail.com>)
Список pgsql-general
Actually we have notice that Auto vacuum in PG10  keeps vacuuming the master tables and  that takes a lot of time and Don't go the child table to remove the dead tuples.

What do the logs say actually got done during these long running autovacuums? Is it feasible to increase the work allowed before autovacuum stops (autovacuum_vacuum_cost_limit) or perhaps increase the number of workers? What is the update/deletes workload balance? That is, would it make sense to decrease the fillfactor on these tables such that you get more HOT (heap only tuple) updates and indexes are less bloated to get better performance that way? How often are you manually vacuuming?

В списке pgsql-general по дате отправления:

Предыдущее
От: Glenn Schultz
Дата:
Сообщение: iterate over partitions
Следующее
От: Benedict Holland
Дата:
Сообщение: create extension points to the wrong directory