Re: Should vacuum process config file reload more often - Mailing list pgsql-hackers

From Daniel Gustafsson
Subject Re: Should vacuum process config file reload more often
Date
Msg-id 5028847C-937A-4CC2-B127-AFF5F9FB79C5@yesql.se
Whole thread Raw
In response to Re: Should vacuum process config file reload more often  (Melanie Plageman <melanieplageman@gmail.com>)
Responses Re: Should vacuum process config file reload more often
List pgsql-hackers
> On 6 Apr 2023, at 23:06, Melanie Plageman <melanieplageman@gmail.com> wrote:

> Autovacuum workers, at the end of VacuumUpdateCosts(), check if cost
> limit or cost delay have been changed. If they have, they assert that
> they don't already hold the AutovacuumLock, take it in shared mode, and
> do the logging.

Another idea would be to copy the values to local temp variables while holding
the lock, and release the lock before calling elog() to avoid holding the lock
over potential IO.

--
Daniel Gustafsson




pgsql-hackers by date:

Previous
From: Melanie Plageman
Date:
Subject: Re: Option to not use ringbuffer in VACUUM, using it in failsafe mode
Next
From: Justin Pryzby
Date:
Subject: Re: Improve logging when using Huge Pages