Wording for using the lock timeout setting

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема Wording for using the lock timeout setting
Дата
Msg-id 171214448951.684.1245168459582460039@wrigleys.postgresql.org
обсуждение исходный текст
Список pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/16/runtime-config-client.html
Description:

Thanks for the cool product. One comment concerning the lock_timeout
parameter:

The documentation states here:
https://www.postgresql.org/docs/16/runtime-config-client.html

"Setting lock_timeout in postgresql.conf is not recommended because it would
affect all sessions."

From my perspective this statement is too strong. There are complex
transaction scenarios where multiple sessions can block the whole system and
a finite value would make sense. When you state "not recommended" this
property is not available in AWS Aurora for example for this reason. I would
assume as you and a number of other database vendors offer such a property,
it should also be usable?  

Just a proposal (you might find a better wording):
"Be aware that setting lock_timeout in postgresql.conf would affect all
sessions."

Thanks for consideration.

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

Предыдущее
От: Daniel Gustafsson
Дата:
Сообщение: [MASSMAIL]tools.ietf.org is decommissioned and our links are redirected
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: tools.ietf.org is decommissioned and our links are redirected