Re: idle_in_transaction_session_timeout

On Sat, May 8, 2021 at 7:55 AM Vijaykumar Jain <
vijaykumarjain(dot)github(at)gmail(dot)com> wrote:

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

>
>
> On Sat, May 8, 2021, 3:58 PM Atul Kumar <akumar14871(at)gmail(dot)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(dot)roberto(at)siscobra(dot)com(dot)br <luis(dot)roberto(at)siscobra(dot)com(dot)br>
>> wrote:
>> >
>> > ----- Mensagem original -----
>> >> De: "Atul Kumar" <akumar14871(at)gmail(dot)com>
>> >> Para: "pgsql-general" <pgsql-general(at)lists(dot)postgresql(dot)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
>> >
>>
>>
>>

--
Regards,
Avinash Vallarapu
+1-902-221-5976