Re: Statement_timeout effect on replication user

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Teja Jakkidi <teja(dot)jakkidi05(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Statement_timeout effect on replication user
Date: 2024-08-07 20:56:16
Message-ID: CAKFQuwZH5H=U3RqBn9AEsXOgyY12LHZZpJbCd_j0Q=N4zw5GaA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Muhammad Imtiaz 2024-08-08 08:43:34 Re: Statement_timeout effect on replication user
Previous Message Rui DeSousa 2024-08-07 20:52:25 Re: Schedule pg_repack job with pg_cron