Postgres Pro
Downloads
Home   >   mailing lists

Re: autovacuum recommendations for Large tables - Mailing list pgsql-general

From Olivier Gautherot
Subject Re: autovacuum recommendations for Large tables
Date
Msg-id CAJ7S9TU1PzTRMBO_7XcbwkVrWXUEHPbbVUv_Q6RLorJnHoPtEg@mail.gmail.com
Whole thread Raw
In response to Re: autovacuum recommendations for Large tables  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: autovacuum recommendations for Large tables
Re: autovacuum recommendations for Large tables
List pgsql-general
Tree view
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 by date:

Previous
From: Devrim Gündüz
Date:
Subject: Re: pg_upgrade from 12 to 13 failes with plpython2
Next
From: Adrian Klaver
Date:
Subject: Re: pg_upgrade from 12 to 13 failes with plpython2