| From: | Sami Imseih <samimseih(at)gmail(dot)com> |
|---|---|
| To: | Nathan Bossart <nathandbossart(at)gmail(dot)com> |
| Cc: | Frédéric Yhuel <frederic(dot)yhuel(at)dalibo(dot)com>, Robert Treat <rob(at)xzilla(dot)net>, wenhui qiu <qiuwenhuifx(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, "Imseih (AWS), Sami" <simseih(at)amazon(dot)com>, David Rowley <dgrowleyml(at)gmail(dot)com>, Joe Conway <mail(at)joeconway(dot)com>, Michael Banck <mbanck(at)gmx(dot)net>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Melanie Plageman <melanieplageman(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: New GUC autovacuum_max_threshold ? |
| Date: | 2025-01-14 19:46:00 |
| Message-ID: | CAA5RZ0u5w=RE13XxUOcywRi4=xQpYYZOSYi71W+EBSoLRYDMzQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Will just park the idea for the documentation here. If
you feel this should be in a follow-up patch, I am ok
with that and will follow-up on it afterwards.
+++ b/doc/src/sgml/maintenance.sgml
@@ -905,6 +905,12 @@ vacuum threshold = Minimum(vacuum max threshold,
vacuum base threshold + vacuum
<xref linkend="guc-autovacuum-vacuum-scale-factor"/>,
and the number of tuples is
<structname>pg_class</structname>.<structfield>reltuples</structfield>.
+ With the default values of <xref
linkend="autovacuum_vacuum_scale_factor"/> and
+ <xref linkend="autovacuum_vacuum_threshold"/>, the <quote>vacuum
threshold</quote> increases as
+ the number of tuples in the table increases; and this reduces the
table's eligibility for
+ <command>VACUUM</command>. Therefore,
+ <xref linkend="autovacuum_vacuum_max_threshold"/> provides a cap
on the number of obsolete rows
+ before the table becomes eligible for a vacuum.
</para>
Regards,
Sami
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Noah Misch | 2025-01-14 19:48:28 | Re: Issue with markers in isolation tester? Or not? |
| Previous Message | David Rowley | 2025-01-14 19:38:27 | Re: Reduce TupleHashEntryData struct size by half |