Re: Transaction timeout - Mailing list pgsql-hackers

From Andrey M. Borodin
Subject Re: Transaction timeout
Date
Msg-id E751C6BA-6885-46B7-B62D-272C2A2A923D@yandex-team.ru
Whole thread Raw
In response to Re: Transaction timeout  (Japin Li <japinli@hotmail.com>)
Responses Re: Transaction timeout
List pgsql-hackers

> On 8 Dec 2023, at 12:59, Japin Li <japinli@hotmail.com> wrote:
>
>
> On Thu, 07 Dec 2023 at 20:40, Andrey M. Borodin <x4mmm@yandex-team.ru> wrote:
>>> On 7 Dec 2023, at 06:25, Japin Li <japinli@hotmail.com> wrote:
>>>
>>> If idle_in_transaction_timeout is bigger than transaction_timeout,
>>> the idle-in-transaction timeout don't needed, right?
>> Yes, I think so.
>>
>
> Should we disable the idle_in_transaction_timeout in this case? Of cursor, I'm
> not strongly insist on this.
Good idea!

> I think you forget disable transaction_timeout in AutoVacWorkerMain().
> If not, can you elaborate on why you don't disable it?

Seems like code in autovacuum.c was copied, but patch was not updated. I’ve fixed this oversight.

Thanks!


Best regards, Andrey Borodin.

Attachment

pgsql-hackers by date:

Previous
From: Jakub Wartak
Date:
Subject: Re: trying again to get incremental backup
Next
From: Alexander Korotkov
Date:
Subject: Re: [HACKERS] make async slave to wait for lsn to be replayed