Re: Autovacuum------Doubts

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Autovacuum------Doubts
Дата
Msg-id CAMkU=1y-w94FSwo3hA7SdGze3EWEynEk0nLzGSgD52Q2mr6tag@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Autovacuum------Doubts  (jaya kumar <kumardba27@gmail.com>)
Список pgsql-admin


On Mon, Apr 8, 2024 at 12:35 PM jaya kumar <kumardba27@gmail.com> wrote:
Hi Jeff,

Superb. Now it's working fine as I expected.

If I will set autovacuum_vacuum_scale_factor parameter value=0 is fine.

If I set production database autovacuum_vacuum_scale_factor parameter 0. Do I face any database performance issues?

Yes, your tables will be vacuumed far more than is sensible.  The vacuum will consume resources that would be better used elsewhere, and some tables that need very frequent vacuuming might be starved of it because it is too busy vacuuming other tables which don't really need it.

If zero were generally a better value, it would have been made the default.  This setting is only useful for pedagogical purposes. I have set it to zero on individual tables on occasion, in conjunction with raising their threshold value, when those tables need to keep their visibility map tuned up.

Cheers,

Jeff

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

Предыдущее
От: jaya kumar
Дата:
Сообщение: Re: Autovacuum------Doubts
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: Work_mem