Implement waiting for given lsn at transaction start
authorAlexander Korotkov <akorotkov@postgresql.org>
Tue, 7 Apr 2020 20:51:10 +0000 (23:51 +0300)
committerAlexander Korotkov <akorotkov@postgresql.org>
Tue, 7 Apr 2020 20:51:10 +0000 (23:51 +0300)
commit0f5ca02f53ac2b211d8518f0882c49284c0c9610
treea5dce13eaa64e00a6ec95b913a155efe7f91c99c
parent357889eb17bb9c9336c4f324ceb1651da616fe57
Implement waiting for given lsn at transaction start

This commit adds following optional clause to BEGIN and START TRANSACTION
commands.

  WAIT FOR LSN lsn [ TIMEOUT timeout ]

New clause pospones transaction start till given lsn is applied on standby.
This clause allows user be sure, that changes previously made on primary would
be visible on standby.

New shared memory struct is used to track awaited lsn per backend.  Recovery
process wakes up backend once required lsn is applied.

Author: Ivan Kartyshov, Anna Akenteva
Reviewed-by: Craig Ringer, Thomas Munro, Robert Haas, Kyotaro Horiguchi
Reviewed-by: Masahiko Sawada, Ants Aasma, Dmitry Ivanov, Simon Riggs
Reviewed-by: Amit Kapila, Alexander Korotkov
Discussion: https://postgr.es/m/0240c26c-9f84-30ea-fca9-93ab2df5f305%40postgrespro.ru
20 files changed:
doc/src/sgml/ref/begin.sgml
doc/src/sgml/ref/start_transaction.sgml
src/backend/access/transam/xlog.c
src/backend/commands/Makefile
src/backend/commands/wait.c [new file with mode: 0644]
src/backend/nodes/copyfuncs.c
src/backend/nodes/equalfuncs.c
src/backend/nodes/outfuncs.c
src/backend/parser/gram.y
src/backend/storage/ipc/ipci.c
src/backend/storage/lmgr/proc.c
src/backend/tcop/utility.c
src/backend/utils/adt/misc.c
src/include/commands/wait.h [new file with mode: 0644]
src/include/nodes/nodes.h
src/include/nodes/parsenodes.h
src/include/parser/kwlist.h
src/include/utils/timestamp.h
src/test/recovery/t/020_begin_wait.pl [new file with mode: 0644]
src/tools/pgindent/typedefs.list