Transaction timeout

Andrey Borodin <amborodin86@gmail.com>

From: Andrey Borodin <amborodin86@gmail.com>

To: Nikolay Samokhvalov <samokhvalov@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2022-12-03T05:18:40Z

Lists: pgsql-hackers

Attachments

v1-0001-Intorduce-transaction_timeout.patch (application/octet-stream) patch v1-0001

Hello,

We have statement_timeout, idle_in_transaction_timeout,
idle_session_timeout and many more! But we have no
transaction_timeout. I've skimmed thread [0,1] about existing timeouts
and found no contraindications to implement transaction_timeout.

Nikolay asked me if I can prototype the feature for testing by him,
and it seems straightforward. Please find attached. If it's not known
to be a bad idea - we'll work on it.

Thanks!

Best regards, Andrey Borodin.

[0] https://www.postgresql.org/message-id/flat/763A0689-F189-459E-946F-F0EC4458980B%40hotmail.com

Commits

Add TAP tests for timeouts
- eeefd4280f6e 17.0 landed
Remove flaky isolation tests for timeouts
- a661bf7b0f56 17.0 landed
Followup fixes for transaction_timeout
- bf82f43790a6 17.0 landed
Introduce transaction_timeout
- 51efe38cb92f 17.0 landed
On systems that have setsid(2) (which should be just about everything except
- 3ad0728c817b 8.2.0 cited