Wording for using the lock timeout setting

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: stephan(dot)volz(at)de(dot)ibm(dot)com
Subject: Wording for using the lock timeout setting
Date: 2024-04-03 11:41:29
Message-ID: 171214448951.684.1245168459582460039@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-docs by date

  From Date Subject
Next Message Magnus Hagander 2024-04-03 12:23:22 Re: tools.ietf.org is decommissioned and our links are redirected
Previous Message Daniel Gustafsson 2024-04-03 11:18:22 tools.ietf.org is decommissioned and our links are redirected