| From: | Vinícius Abrahão <vinnix(dot)bsd(at)gmail(dot)com> |
|---|---|
| To: | Nathan Bossart <nathandbossart(at)gmail(dot)com> |
| Cc: | Frédéric Yhuel <frederic(dot)yhuel(at)dalibo(dot)com>, 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-08 21:32:58 |
| Message-ID: | CAM9Bftw+UQ4QWHWZiGmyEhywX0RN1cPPuwcBeRPWyQzT_Jdifg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Jan 8, 2025 at 8:01 PM Nathan Bossart <nathandbossart(at)gmail(dot)com>
wrote:
> On Wed, Jan 08, 2025 at 02:48:10PM +0100, Frédéric Yhuel wrote:
> > For what it's worth, although I would have preferred the sub-linear
> growth
> > thing, I'd much rather have this than nothing.
>
> +1, this is how I feel, too. But I also don't want to add something that
> folks won't find useful.
>
> > And I have to admit that the proposed formulas were either too
> convoluted or
> > wrong.
> >
> > This very patch is more straightforward. Please let me know if I can help
> > and how.
>
> I read through the thread from the top, and it does seem like there is
> reasonably strong support for the hard cap. Upon a closer review of the
> patch, I noticed that the relopt was defined such that you couldn't disable
> autovacuum_max_threshold on a per-table basis, so I fixed that in v4.
>
> --
> nathan
>
nathan,
Please also provide the tests on the new parameter you want to introduce.
Best,
vini
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2025-01-08 21:37:35 | Re: EphemeralNamedRelation and materialized view |
| Previous Message | Ilia Evdokimov | 2025-01-08 21:25:15 | Re: Sample rate added to pg_stat_statements |