Re: autovacuum recommendations for Large tables

On Tue, 2020-11-17 at 22:17 +0100, Olivier Gautherot wrote:
> 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:
> https://sites.google.com/gautherot.net/postgresql/vacuum 
> 
> Hope you find it useful.

Then I can chime in with https://www.cybertec-postgresql.com/en/tuning-autovacuum-postgresql/

Yours,
Laurenz Albe