Обсуждение: Wording for using the lock timeout setting

Поиск
Список
Период
Сортировка

Wording for using the lock timeout setting

От
PG Doc comments form
Дата:
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.