public inbox for [email protected]  

help / color / mirror / Atom feed

From: Muhammad Imtiaz <[email protected]>
To: David G. Johnston <[email protected]>
Cc: Teja Jakkidi <[email protected]>
Cc: pgsql-admin <[email protected]>
Subject: Re: Statement_timeout effect on replication user
Date: Thu, 8 Aug 2024 13:43:34 +0500
Message-ID: <CACW1Ly0reU+PYtn8adDNuhhXcC=FLjbYdBfnor9wCEf3gdZpmw@mail.gmail.com> (raw)
In-Reply-To: <CAKFQuwZH5H=U3RqBn9AEsXOgyY12LHZZpJbCd_j0Q=N4zw5GaA@mail.gmail.com>
References: <[email protected]>
	<CAKFQuwZH5H=U3RqBn9AEsXOgyY12LHZZpJbCd_j0Q=N4zw5GaA@mail.gmail.com>

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.
>
>

view thread (3+ messages)

reply

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: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Statement_timeout effect on replication user
  In-Reply-To: <CACW1Ly0reU+PYtn8adDNuhhXcC=FLjbYdBfnor9wCEf3gdZpmw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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