Postgres Pro
Downloads
Home   >   mailing lists

Re: Statement_timeout effect on replication user - Mailing list pgsql-admin

From David G. Johnston
Subject Re: Statement_timeout effect on replication user
Date
Msg-id CAKFQuwZH5H=U3RqBn9AEsXOgyY12LHZZpJbCd_j0Q=N4zw5GaA@mail.gmail.com
Whole thread Raw
In response to Statement_timeout effect on replication user  (Teja Jakkidi <teja.jakkidi05@gmail.com>)
Responses Re: Statement_timeout effect on replication user
List pgsql-admin
Tree view
On Wednesday, August 7, 2024, Teja Jakkidi <teja.jakkidi05@gmail.com> wrote:

I am trying to set statement_timeout parameter to 1 hour at instance level due to some production issues that we have noticed with long running queries.
We also have hot stand by replication setup using a user with replication privilege. Now, if I setup statement_timeout at instance level, will this affect the replication session as well?

Set it to 10 seconds and see if anything breaks?

I would doubt it since replication doesn’t involve SQL statements.

David J.

pgsql-admin by date:

Previous
From: Rui DeSousa
Date:
Subject: Re: Schedule pg_repack job with pg_cron
Next
From: Muhammad Imtiaz
Date:
Subject: Re: Statement_timeout effect on replication user