autovacuum recommendations for Large tables

From: Atul Kumar <akumar14871(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: autovacuum recommendations for Large tables
Date: 2020-11-16 17:38:39
Message-ID: CA+ONtZ6Fc5CghGQn1iAwxitK_X_5FoV-nxgAKEFEbvNTYOZ04w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2020-11-16 18:02:55 Re: Unable to compile postgres 13.1 on Slackware current x64
Previous Message Tom Lane 2020-11-16 17:30:03 Re: Unable to compile postgres 13.1 on Slackware current x64