Обсуждение: pgsql: Speedup 2PC recovery by skipping two phase state files innormal

Поиск
Список
Период
Сортировка

pgsql: Speedup 2PC recovery by skipping two phase state files innormal

От
Simon Riggs
Дата:
Speedup 2PC recovery by skipping two phase state files in normal path

2PC state info held in shmem at PREPARE, then cleaned at COMMIT PREPARED/ABORT PREPARED,
avoiding writing/fsyncing any state information to disk in the normal path, greatly enhancing replay speed.
Prepared transactions that live past one checkpoint redo horizon will be written to disk as now.
Similar conceptually to 978b2f65aa1262eb4ecbf8b3785cb1b9cf4db78e and building upon
the infrastructure created by that commit.

Authors, in equal measure: Stas Kelvich, Nikhil Sontakke and Michael Paquier
Discussion: https://postgr.es/m/CAMGcDxf8Bn9ZPBBJZba9wiyQq-Qk5uqq=VjoMnRnW5s+fKST3w@mail.gmail.com

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/728bd991c3c4389fb39c45dcb0fe57e4a1dccd71

Modified Files
--------------
src/backend/access/transam/twophase.c | 821 ++++++++++++++++++++++------------
src/backend/access/transam/xact.c     |  18 +-
src/backend/access/transam/xlog.c     |  10 +
src/include/access/twophase.h         |   7 +-
4 files changed, 550 insertions(+), 306 deletions(-)