Re: autovacuum recommendations for Large tables

Поиск

Список

Период

Сортировка

От	Olivier Gautherot
Тема	Re: autovacuum recommendations for Large tables
Дата	18 ноября 2020 г. 00:17:05
Msg-id	CAJ7S9TU1PzTRMBO_7XcbwkVrWXUEHPbbVUv_Q6RLorJnHoPtEg@mail.gmail.com обсуждение исходный текст
Ответ на	Re: autovacuum recommendations for Large tables ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы	Re: autovacuum recommendations for Large tables (Rob Sargent <robjsargent@gmail.com>) Re: autovacuum recommendations for Large tables (Laurenz Albe <laurenz.albe@cybertec.at>)
Список	pgsql-general

Дерево обсуждения

Hi Atul,

On Tue, Nov 17, 2020 at 12:05 AM David G. Johnston <david.g.johnston@gmail.com> wrote:

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.