number of updated or deleted tuples needed to trigger a VACUUM in any one table

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: number of updated or deleted tuples needed to trigger a VACUUM in any one table
Date: 2024-11-07 15:30:40
Message-ID: CANzqJaDh3vYp2dej87Oq=gOTrQS-3C9kOPgGgTeEQa7ku9bRDA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

https://www.postgresql.org/docs/current/runtime-config-autovacuum.html

autovacuum_vacuum_threshold (integer)
<https://www.postgresql.org/docs/current/runtime-config-autovacuum.html#GUC-AUTOVACUUM-VACUUM-THRESHOLD>

Specifies the minimum number of updated or deleted tuples needed to trigger
a VACUUM in any one table.

Are the number of updated and deleted tuples since the last vacuum exposed
anywhere, like n_ins_since_vacuum is exposed?

I've Googled with no luck.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Murthy Nunna 2024-11-07 16:35:10 Running rsync backups in pg15
Previous Message Norbert Poellmann 2024-11-07 13:55:30 GRANT and predefined role