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

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема pgsql: Speedup 2PC recovery by skipping two phase state files innormal
Дата
Msg-id E1cvUai-000415-8W@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
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(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: pgsql: Adjust min/max values when changing sequence type
Следующее
От: Andrew Dunstan
Дата:
Сообщение: pgsql: Clarify documentation of to_tsvector(json(b))