pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedsuggestion about statement_timeout
3+ messages / 2 participants
[nested] [flat]
* suggestion about statement_timeout
@ 2024-09-01 03:36 yanliang lei <msdnchina@163.com>
2024-09-01 03:48 ` Re: suggestion about statement_timeout David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: yanliang lei @ 2024-09-01 03:36 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: suggestion about statement_timeout
2024-09-01 03:36 suggestion about statement_timeout yanliang lei <msdnchina@163.com>
@ 2024-09-01 03:48 ` David G. Johnston <david.g.johnston@gmail.com>
2024-09-01 13:38 ` Re:Re: suggestion about statement_timeout yanliang lei <msdnchina@163.com>
0 siblings, 1 reply; 3+ messages in thread
From: David G. Johnston @ 2024-09-01 03:48 UTC (permalink / raw)
To: yanliang lei <msdnchina@163.com>; +Cc: pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re:Re: suggestion about statement_timeout
2024-09-01 03:36 suggestion about statement_timeout yanliang lei <msdnchina@163.com>
2024-09-01 03:48 ` Re: suggestion about statement_timeout David G. Johnston <david.g.johnston@gmail.com>
@ 2024-09-01 13:38 ` yanliang lei <msdnchina@163.com>
0 siblings, 0 replies; 3+ messages in thread
From: yanliang lei @ 2024-09-01 13:38 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-09-01 13:38 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-09-01 03:36 suggestion about statement_timeout yanliang lei <msdnchina@163.com>
2024-09-01 03:48 ` David G. Johnston <david.g.johnston@gmail.com>
2024-09-01 13:38 ` yanliang lei <msdnchina@163.com>
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