public inbox for [email protected]  

help / color / mirror / Atom feed

Statement_timeout effect on replication user
3+ messages / 3 participants
[nested] [flat]

* Statement_timeout effect on replication user
@ 2024-08-07 20:47 Teja Jakkidi <[email protected]>
  2024-08-07 20:56 ` Re: Statement_timeout effect on replication user David G. Johnston <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Teja Jakkidi @ 2024-08-07 20:47 UTC (permalink / raw)
  To: pgsql-admin <[email protected]>

Hello Postgres Admins,

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?

Thanks,
J. Teja.




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Statement_timeout effect on replication user
  2024-08-07 20:47 Statement_timeout effect on replication user Teja Jakkidi <[email protected]>
@ 2024-08-07 20:56 ` David G. Johnston <[email protected]>
  2024-08-08 08:43   ` Re: Statement_timeout effect on replication user Muhammad Imtiaz <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: David G. Johnston @ 2024-08-07 20:56 UTC (permalink / raw)
  To: Teja Jakkidi <[email protected]>; +Cc: pgsql-admin <[email protected]>

On Wednesday, August 7, 2024, Teja Jakkidi <[email protected]> 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.


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Statement_timeout effect on replication user
  2024-08-07 20:47 Statement_timeout effect on replication user Teja Jakkidi <[email protected]>
  2024-08-07 20:56 ` Re: Statement_timeout effect on replication user David G. Johnston <[email protected]>
@ 2024-08-08 08:43   ` Muhammad Imtiaz <[email protected]>
  0 siblings, 0 replies; 3+ messages in thread

From: Muhammad Imtiaz @ 2024-08-08 08:43 UTC (permalink / raw)
  To: David G. Johnston <[email protected]>; +Cc: Teja Jakkidi <[email protected]>; pgsql-admin <[email protected]>

Hi,

Setting statement_timeout to 1 hour means that any query running longer
than 1 hour will be automatically stopped. This applies to queries from
applications or users, including those with replication privileges.
However, this timeout does not affect the replication process itself. The
continuous transfer of WAL files from the primary server to replicas will
continue as usual, unaffected by the statement_timeout setting.

Regards,
Muhammad Imtiaz

On Thu, Aug 8, 2024 at 1:56 AM David G. Johnston <[email protected]>
wrote:

> On Wednesday, August 7, 2024, Teja Jakkidi <[email protected]>
> 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.
>
>


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2024-08-08 08:43 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-08-07 20:47 Statement_timeout effect on replication user Teja Jakkidi <[email protected]>
2024-08-07 20:56 ` David G. Johnston <[email protected]>
2024-08-08 08:43   ` Muhammad Imtiaz <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox