Re: pg_reload_conf() synchronously

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_reload_conf() synchronously
Дата
Msg-id 2527794.1667619321@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_reload_conf() synchronously  (Andres Freund <andres@anarazel.de>)
Ответы Re: pg_reload_conf() synchronously  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> Worth noting that this doesn't necessarily suffice to avoid race conditions in
> tests, if the test depends on *other* backends having seen the configuration
> changes.

True, but do we have any such cases?

> It might be worth to use the global barrier mechanism to count which backends
> have reloaded configuration and to provide a function / option to pg_sleep
> that waits for that.

That ... seems like a lot of mechanism.  And it could easily result
in undetected deadlocks, if any other session is blocked on you.
I seriously doubt that we should go there.

            regards, tom lane



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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Incorrect include file order in guc-file.l
Следующее
От: Andres Freund
Дата:
Сообщение: Re: pg_reload_conf() synchronously