suggestion about statement_timeout

On Saturday, August 31, 2024, yanliang lei <msdnchina@163.com> wrote:

hi，
in the https://techcommunity.microsoft.com/t5/azure-
database-for-postgresql/connection-handling-best-
practice-with-postgresql/ba-p/790883
there is the following description：
alter database dbnamehere set statement_timeout = 60000;

but the the https://www.postgresql.org/docs/current/runtime-
config-client.html
where is no description that statement_timeout can be used at the database
level

so，i suggestion：adding some description that statement_timeout can be
used at the database level

All client connection default settings can be attached to either a role, a
database, or both. In fact, the majority of settings can, and so unless
stated otherwise, the guidance in 20.1.3 is meant to be taken as being
applicable. And in any case, this particular setting is in no way special
should one wish to suggest a concrete change.

David J.

I got it。

thanks a lot

在 2024-09-01 11:48:33，"David G. Johnston" <david.g.johnston@gmail.com> 写道：

On Saturday, August 31, 2024, yanliang lei <msdnchina@163.com> wrote:

hi，
in the https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/connection-handling-best-practice-with-postgresql/ba-p/790883
there is the following description：
alter database dbnamehere set statement_timeout = 60000;

but the the https://www.postgresql.org/docs/current/runtime-config-client.html
where is no description that statement_timeout can be used at the database level

so，i suggestion：adding some description that statement_timeout can be used at the database level

All client connection default settings can be attached to either a role, a database, or both. In fact, the majority of settings can, and so unless stated otherwise, the guidance in 20.1.3 is meant to be taken as being applicable. And in any case, this particular setting is in no way special should one wish to suggest a concrete change.

David J.