Re: suggestion about statement_timeout

On Saturday, August 31, 2024, yanliang lei <msdnchina(at)163(dot)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.