Postgres Pro
Downloads
Home   >   mailing lists

number of updated or deleted tuples needed to trigger a VACUUM in any one table - Mailing list pgsql-admin

From Ron Johnson
Subject number of updated or deleted tuples needed to trigger a VACUUM in any one table
Date
Msg-id CANzqJaDh3vYp2dej87Oq=gOTrQS-3C9kOPgGgTeEQa7ku9bRDA@mail.gmail.com
Whole thread Raw
Responses Re: number of updated or deleted tuples needed to trigger a VACUUM in any one table
List pgsql-admin
Tree view


autovacuum_vacuum_threshold (integer) 

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!

pgsql-admin by date:

Previous
From: Norbert Poellmann
Date:
Subject: GRANT and predefined role
Next
From: Murthy Nunna
Date:
Subject: Running rsync backups in pg15