Re: Trigger more frequent autovacuums of heavy insert tables

From: Nathan Bossart <nathandbossart(at)gmail(dot)com>
To: Melanie Plageman <melanieplageman(at)gmail(dot)com>
Cc: Robert Treat <rob(at)xzilla(dot)net>, Greg Sabino Mullane <htamfids(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Andres Freund <andres(at)anarazel(dot)de>, Peter Geoghegan <pg(at)bowt(dot)ie>, David Rowley <dgrowley(at)gmail(dot)com>, Corey Huinker <corey(dot)huinker(at)gmail(dot)com>
Subject: Re: Trigger more frequent autovacuums of heavy insert tables
Date: 2025-11-11 18:48:39
Message-ID: aRODeqFUVkGDJSPP@nathan
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Mar 03, 2025 at 02:47:33PM -0500, Melanie Plageman wrote:
> cool, I've changed it to this, pushed, and marked the commitfest entry
> as committed.
> Thanks so much for your attention and review!

I think maintenance.sgml needs an update (specifically, the part about the
insert threshold [0]).

[0] https://www.postgresql.org/docs/devel/routine-vacuuming.html#AUTOVACUUM

--
nathan

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bryan Green 2025-11-11 19:22:49 Re: [Patch] Windows relation extension failure at 2GB and 4GB
Previous Message Heikki Linnakangas 2025-11-11 17:08:38 Re: Move SLRU_PAGES_PER_SEGMENT to pg_config_manual.h