From: | Muhammad Imtiaz <imtiazpg712(at)gmail(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | Teja Jakkidi <teja(dot)jakkidi05(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Statement_timeout effect on replication user |
Date: | 2024-08-08 08:43:34 |
Message-ID: | CACW1Ly0reU+PYtn8adDNuhhXcC=FLjbYdBfnor9wCEf3gdZpmw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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 <david(dot)g(dot)johnston(at)gmail(dot)com>
wrote:
> On Wednesday, August 7, 2024, Teja Jakkidi <teja(dot)jakkidi05(at)gmail(dot)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.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | shammat | 2024-08-08 10:16:53 | Re: Schedule pg_repack job with pg_cron |
Previous Message | David G. Johnston | 2024-08-07 20:56:16 | Re: Statement_timeout effect on replication user |