From: yanliang lei <msdnchina@163.com>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
Subject: Re:Re: suggestion about statement_timeout
Date: Sun, 1 Sep 2024 21:38:04 +0800 (CST)
Message-ID: <9808b0e.2a6d.191adce9ae7.Coremail.msdnchina@163.com> (raw)
In-Reply-To: <CAKFQuwZVjFjHQkRG9K5o9mBkyqP+3MouwwN+TYQeHqPBs0oecw@mail.gmail.com>
References: <2275083f.e60.191aba8134a.Coremail.msdnchina@163.com>
<CAKFQuwZVjFjHQkRG9K5o9mBkyqP+3MouwwN+TYQeHqPBs0oecw@mail.gmail.com>
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-practi...
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: msdnchina@163.com, david.g.johnston@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re:Re: suggestion about statement_timeout
In-Reply-To: <9808b0e.2a6d.191adce9ae7.Coremail.msdnchina@163.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox