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 > 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

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

> > 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

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

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

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

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

autovacuum recommendations for Large tables

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 this table so that our time can be spent better than repeatedly vacuuming large tables. Please help. Regards, Atul