Re: Transaction timeout - Mailing list pgsql-hackers

From Andrey M. Borodin
Subject Re: Transaction timeout
Date
Msg-id D9412036-76BA-4B31-8DB7-F7BE37CA0437@yandex-team.ru
Whole thread Raw
In response to Re: Transaction timeout  (Junwang Zhao <zhjwpku@gmail.com>)
Responses Re: Transaction timeout
List pgsql-hackers

> On 29 Dec 2023, at 16:00, Junwang Zhao <zhjwpku@gmail.com> wrote:
>
> After exploring the code, I found scheduling the timeout in
> `StartTransaction` might be a reasonable idea, all the chain
> commands will call this function.
>
> What concerns me is that it is also called by StartParallelWorkerTransaction,
> I'm not sure if we should enable this timeout for parallel execution.

I think for parallel workers we should mimic statement_timeout. Because these workers have per-statemenent lifetime.


Best regards, Andrey Borodin.


pgsql-hackers by date:

Previous
From: Junwang Zhao
Date:
Subject: Re: Transaction timeout
Next
From: Jelte Fennema-Nio
Date:
Subject: Re: Add PQsendSyncMessage() to libpq