Re: idle_in_transaction_session_timeout - Mailing list pgsql-general

From Vijaykumar Jain
Subject Re: idle_in_transaction_session_timeout
Date
Msg-id CAM+6J95G4Yt25CzEH1z+6GAfEYLuo9Dq-rjQMoWKwn4vg-Y_-A@mail.gmail.com
Whole thread Raw
In response to Re: idle_in_transaction_session_timeout  (Atul Kumar <akumar14871@gmail.com>)
Responses Re: idle_in_transaction_session_timeout
List pgsql-general
Why do you want to increase that timeout ?
I hope you are aware long idle in transactions connections would delay vacuuming and result in much larger bloats and slow down the db over period of time.
You need to upgrade and push using the reasons that these are not supported.
asking for workarounds around an unsupported version  will only increase headaches in the future.


On Sat, May 8, 2021, 3:58 PM Atul Kumar <akumar14871@gmail.com> wrote:
ok, But what is the workaround of this parameter in postgres 9.5, ,I
need to increase the time of "idle in transaction" transactions.





Regards,
Atul







On 5/7/21, luis.roberto@siscobra.com.br <luis.roberto@siscobra.com.br> wrote:
>
> ----- Mensagem original -----
>> De: "Atul Kumar" <akumar14871@gmail.com>
>> Para: "pgsql-general" <pgsql-general@lists.postgresql.org>
>> Enviadas: Sexta-feira, 7 de maio de 2021 3:34:44
>> Assunto: idle_in_transaction_session_timeout
>
>> Hi,
>
>> I have postgres 9.5 version running on my machine.
>
>> When I am trying to find out the parameter
>> idle_in_transaction_session_timeout it is showing me below error:
>
>> postgres=# show idle_in_transaction_session_timeout;
>> ERROR: unrecognized configuration parameter
>> "idle_in_transaction_session_timeout"
>
>> I also checked postgresql.conf but even in this file there is no such
>> parameter.
>
>> Please help me to find this parameter.
>
>> Regards,
>> Atul
>
> idle_in_transaction_session_timeout first appears in v9.6[1]
>
> [1] https://www.postgresql.org/docs/9.6/runtime-config-client.html
>
> Luis R. Weck
>


pgsql-general by date:

Previous
From: Atul Kumar
Date:
Subject: Re: idle_in_transaction_session_timeout
Next
From: "sivapostgres@yahoo.com"
Date:
Subject: Re: Issue in PG start