git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 5c9f2f9) | patch
Introduce transaction_timeout
2024年2月15日 21:34:11 +0000 (23:34 +0200)
2024年2月15日 21:56:12 +0000 (23:56 +0200)
commit 51efe38cb92f4b15b68811bcce9ab878fbc71ea5
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>
23 files changed:
doc/src/sgml/config.sgml diff | blob | blame | history
src/backend/access/transam/xact.c diff | blob | blame | history
src/backend/postmaster/autovacuum.c diff | blob | blame | history
src/backend/storage/lmgr/proc.c diff | blob | blame | history
src/backend/tcop/postgres.c diff | blob | blame | history
src/backend/utils/errcodes.txt diff | blob | blame | history
src/backend/utils/init/globals.c diff | blob | blame | history
src/backend/utils/init/postinit.c diff | blob | blame | history
src/backend/utils/misc/guc_tables.c diff | blob | blame | history
src/backend/utils/misc/postgresql.conf.sample diff | blob | blame | history
src/bin/pg_dump/pg_backup_archiver.c diff | blob | blame | history
src/bin/pg_dump/pg_dump.c diff | blob | blame | history
src/bin/pg_rewind/libpq_source.c diff | blob | blame | history
src/include/miscadmin.h diff | blob | blame | history
src/include/storage/proc.h diff | blob | blame | history
src/include/utils/guc_hooks.h diff | blob | blame | history
src/include/utils/timeout.h diff | blob | blame | history
src/test/isolation/Makefile diff | blob | blame | history
src/test/isolation/expected/timeouts-long.out [new file with mode: 0644] blob
src/test/isolation/expected/timeouts.out diff | blob | blame | history
src/test/isolation/isolation_schedule diff | blob | blame | history
src/test/isolation/specs/timeouts-long.spec [new file with mode: 0644] blob
src/test/isolation/specs/timeouts.spec diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

AltStyle によって変換されたページ (->オリジナル) /