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.
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 |