Re: Add log_autovacuum_{vacuum|analyze}_min_duration

From: Shinya Kato <shinya11(dot)kato(at)gmail(dot)com>
To: Sami Imseih <samimseih(at)gmail(dot)com>
Cc: wenhui qiu <qiuwenhuifx(at)gmail(dot)com>, Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>, Nathan Bossart <nathandbossart(at)gmail(dot)com>, Michael Banck <mbanck(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Add log_autovacuum_{vacuum|analyze}_min_duration
Date: 2025-07-02 06:37:49
Message-ID: CAOzEurQA4E1=B_e+HTjOPyr0uHR7+E5nb63FgjGVGPZdPJxAfw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Jun 23, 2025 at 4:24 PM Shinya Kato <shinya11(dot)kato(at)gmail(dot)com> wrote:
>
> On Wed, Jun 11, 2025 at 1:49 PM Shinya Kato <shinya11(dot)kato(at)gmail(dot)com> wrote:
>>
>> On Thu, Jun 5, 2025 at 3:53 AM Sami Imseih <samimseih(at)gmail(dot)com> wrote:
>>>
>>> > Approach 2:
>>> > - log_autovacuum_min_duration: Changed behavior, which controls only
>>> > autovacuum logging.
>>> > - log_autoanalyze_min_duration: New parameter, which controls
>>> > autoanalyze logging.
>>>
>>> My vote is for this approach. It is probably OK to change the behavior of
>>> log_autovacuum_min_duration, as the new GUC will have the same default
>>> value.
>>
>>
>> Thank you for voting. I also think this approach is reasonable to implement.
>
>
> A new patch is attached.
> Thoughts?

Rebased.

--
Best regards,
Shinya Kato
NTT OSS Center

Attachment Content-Type Size
v3-0001-Add-log_autoanalyze_min_duration.patch application/octet-stream 21.8 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bertrand Drouvot 2025-07-02 06:39:25 Re: Add os_page_num to pg_buffercache
Previous Message Peter Smith 2025-07-02 06:34:02 Re: [WIP]Vertical Clustered Index (columnar store extension) - take2