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

From David G. Johnston
Subject Re: autovacuum recommendations for Large tables
Date
Msg-id CAKFQuwYWLB82jh8ZLq91E4w_YLH8=-HBon0R8kUSjw34D4=AUA@mail.gmail.com
Whole thread Raw
In response to Re: autovacuum recommendations for Large tables  (Atul Kumar <akumar14871@gmail.com>)
Responses Re: autovacuum recommendations for Large tables  (Olivier Gautherot <ogautherot@gautherot.net>)
List 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 by date:

Previous
From: Atul Kumar
Date:
Subject: Re: autovacuum recommendations for Large tables
Next
From: Kevin Brannen
Date:
Subject: RE: New "function tables" in V13 documentation