Re: Sub-millisecond [autovacuum_]vacuum_cost_delay broken

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Sub-millisecond [autovacuum_]vacuum_cost_delay broken
Дата
Msg-id 658998.1678403879@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Sub-millisecond [autovacuum_]vacuum_cost_delay broken  (Melanie Plageman <melanieplageman@gmail.com>)
Список pgsql-hackers
Melanie Plageman <melanieplageman@gmail.com> writes:
> On Thu, Mar 9, 2023 at 5:27 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> A minimalistic fix could be as attached.  I'm not sure if it's worth
>> making the state variable global so that it can be reset to zero in
>> the places where we zero out VacuumCostBalance etc.  Also note that
>> this is ignoring the VacuumSharedCostBalance stuff, so you'd possibly
>> have the extra delay accumulating in unexpected places when there are
>> multiple workers.  But I really doubt it's worth worrying about that.

> What if someone resets the delay guc and there is still a large residual?

By definition, the residual is less than 1msec.

            regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Juan José Santamaría Flecha
Дата:
Сообщение: Re: pg_dump/pg_restore: Fix stdin/stdout handling of custom format on Win32
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: buildfarm + meson