Re: autovacuum recommendations for Large tables

2020-11-18 Thread Laurenz Albe
On Tue, 2020-11-17 at 22:17 +0100, Olivier Gautherot wrote: > On Tue, Nov 17, 2020 at 12:05 AM David G. Johnston > wrote: > > On Mon, Nov 16, 2020 at 3:57 PM Atul Kumar wrote: > > > I only have this one big table in the database of size 3113 GB with rows > > > 7661353111. > > > > > > Right Now

Re: autovacuum recommendations for Large tables

2020-11-17 Thread Olivier Gautherot
Hi Rob, On Tue, Nov 17, 2020 at 10:24 PM Rob Sargent wrote: > 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. > -- > > That URL does not work for me (not even > https://sites.google.c

Re: autovacuum recommendations for Large tables

2020-11-17 Thread Rob Sargent
> > 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. > -- That URL does not work for me (not even https://sites.google.

Re: autovacuum recommendations for Large tables

2020-11-17 Thread Olivier Gautherot
Hi Atul, On Tue, Nov 17, 2020 at 12:05 AM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Mon, Nov 16, 2020 at 3:57 PM Atul Kumar 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

Re: autovacuum recommendations for Large tables

2020-11-16 Thread David G. Johnston
On Mon, Nov 16, 2020 at 3:57 PM Atul Kumar 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=

Re: autovacuum recommendations for Large tables

2020-11-16 Thread Atul Kumar
Hi, Could you help me by explaining in simple words, as I am new to postgres. What value of which parameter should I set and why. 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=tr

Re: autovacuum recommendations for Large tables

2020-11-16 Thread Andreas Schmitz
https://www.postgresql.org/docs/13/routine-vacuuming.html Regards Andreas Am 11/16/2020 um 6:38 PM schrieb Atul Kumar: > Hi, > > I have a large table having no. of live tuples approx 7690798868 and > no. of dead tuples approx 114917737. > > So Please share autovacuum tuning recommendations for t