Re: autovacuum recommendations for Large tables

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: autovacuum recommendations for Large tables
Дата
Msg-id CAKFQuwYWLB82jh8ZLq91E4w_YLH8=-HBon0R8kUSjw34D4=AUA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: autovacuum recommendations for Large tables  (Atul Kumar <akumar14871@gmail.com>)
Ответы Re: autovacuum recommendations for Large tables  (Olivier Gautherot <ogautherot@gautherot.net>)
Список pgsql-general
On Mon, Nov 16, 2020 at 3:57 PM Atul Kumar <akumar14871@gmail.com> wrote:
I only have this one big table in the database of size 3113 GB with rows 7661353111.

Right Now the autovacuum setting for that table is set to
{autovacuum_enabled=true,autovacuum_vacuum_scale_factor=0.2,autovacuum_analyze_scale_factor=0.2}


auto-vacuum doesn't care directly about absolute size, it cares about change (relative to absolute size in many cases, hence the scale factors).

David J.

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

Предыдущее
От: Atul Kumar
Дата:
Сообщение: Re: autovacuum recommendations for Large tables
Следующее
От: Kevin Brannen
Дата:
Сообщение: RE: New "function tables" in V13 documentation