Re: New GUC autovacuum_max_threshold ?

From: wenhui qiu <qiuwenhuifx(at)gmail(dot)com>
To: Nathan Bossart <nathandbossart(at)gmail(dot)com>
Cc: Vinícius Abrahão <vinnix(dot)bsd(at)gmail(dot)com>, Frédéric Yhuel <frederic(dot)yhuel(at)dalibo(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-10 01:45:42
Message-ID: CAGjGUAKQQu2Pvys-zSo12tYXhim8uhAT6Vr8xi0enf9B-jMrrw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

HI Nathan Frédéric Yhuel
On 1/7/25 23:57, Nathan Bossart wrote:
> Here is a rebased patch for cfbot. AFAICT we are still pretty far from
> consensus on which approach to take, unfortunately.
>

> For what it's worth, although I would have preferred the sub-linear
> growth thing, I'd much rather have this than nothing.
Agree , Better late than never. But I personally think a GUC parameter can
also be added, allowing users to choose the algorithm that works better,
especially since SQL Server is a pioneer in this area."

On Fri, Jan 10, 2025 at 2:20 AM Nathan Bossart <nathandbossart(at)gmail(dot)com>
wrote:

> On Wed, Jan 08, 2025 at 09:32:58PM +0000, Vinícius Abrahão wrote:
> > Please also provide the tests on the new parameter you want to introduce.
>
> I skimmed around and didn't see any existing tests for these kinds of
> parameters, which of course isn't a great reason not to add tests, but it's
> also not clear what such tests might look like. Do you have any ideas?
>
> --
> nathan
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2025-01-10 01:46:46 Re: Make pg_stat_io view count IOs as bytes instead of blocks
Previous Message Peter Smith 2025-01-10 01:26:04 Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size