Re: autovacuum recommendations for Large tables

Поиск
Список
Период
Сортировка
От Olivier Gautherot
Тема Re: autovacuum recommendations for Large tables
Дата
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
Re: autovacuum recommendations for Large tables
Список 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.

David is correct.

If it helps, I put together a few thoughts and own experience on a blog:

Hope you find it useful.
--
Olivier Gautherot


Libre de virus. www.avast.com

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