Horton

Introduce transaction_timeout

Alexander Korotkov <akorotkov@postgresql.org>

View on postgr.es
Commit: 51efe38cb92f4b15b68811bcce9ab878fbc71ea5
Author: Alexander Korotkov <akorotkov@postgresql.org>
Date: 2024-02-15T21:56:12Z
Releases: 17.0 
Introduce transaction_timeout

This commit adds timeout that is expected to be used as a prevention
of long-running queries. Any session within the transaction will be
terminated after spanning longer than this timeout.

However, this timeout is not applied to prepared transactions.
Only transactions with user connections are affected.

Discussion: https://postgr.es/m/CAAhFRxiQsRs2Eq5kCo9nXE3HTugsAAJdSQSmxncivebAxdmBjQ%40mail.gmail.com
Author: Andrey Borodin <amborodin@acm.org>
Author: Japin Li <japinli@hotmail.com>
Author: Junwang Zhao <zhjwpku@gmail.com>
Reviewed-by: Nikolay Samokhvalov <samokhvalov@gmail.com>
Reviewed-by: Andres Freund <andres@anarazel.de>
Reviewed-by: Fujii Masao <masao.fujii@oss.nttdata.com>
Reviewed-by: bt23nguyent <bt23nguyent@oss.nttdata.com>
Reviewed-by: Yuhang Qiu <iamqyh@gmail.com>

Files

PathChange+/−
doc/src/sgml/config.sgml modified +36 −0
src/backend/access/transam/xact.c modified +4 −0
src/backend/postmaster/autovacuum.c modified +2 −0
src/backend/storage/lmgr/proc.c modified +1 −0
src/backend/tcop/postgres.c modified +43 −3
src/backend/utils/errcodes.txt modified +1 −0
src/backend/utils/init/globals.c modified +1 −0
src/backend/utils/init/postinit.c modified +10 −0
src/backend/utils/misc/guc_tables.c modified +11 −0
src/backend/utils/misc/postgresql.conf.sample modified +1 −0
src/bin/pg_dump/pg_backup_archiver.c modified +1 −0
src/bin/pg_dump/pg_dump.c modified +2 −0
src/bin/pg_rewind/libpq_source.c modified +1 −0
src/include/miscadmin.h modified +1 −0
src/include/storage/proc.h modified +1 −0
src/include/utils/guc_hooks.h modified +1 −0
src/include/utils/timeout.h modified +1 −0
src/test/isolation/expected/timeouts-long.out added +69 −0
src/test/isolation/expected/timeouts.out modified +78 −1
src/test/isolation/isolation_schedule modified +1 −0
src/test/isolation/Makefile modified +3 −0
src/test/isolation/specs/timeouts-long.spec added +35 −0
src/test/isolation/specs/timeouts.spec modified +39 −1

Documentation touched

Discussion