Skip to content

Commit 9b47607

Browse files
kelvichvbwagner
kelvich
authored and
vbwagner
committed
Backpatch of 978b2f6:
> Speedup 2PC by skipping two phase state files in normal path > 2PC state info is written only to WAL at PREPARE, then read back from WAL at > COMMIT PREPARED/ABORT PREPARED. Prepared transactions that live past one bufmgr > checkpoint cycle will be written to disk in the same form as previously. Crash > recovery path is not altered. Measured performance gains of 50-100% for short > 2PC transactions by completely avoiding writing files and fsyncing. Other > optimizations still available, further patches in related areas expected. > > Stas Kelvich and heavily edited by Simon Riggs > > Based upon earlier ideas and patches by Michael Paquier and Heikki Linnakangas, > a concrete example of how Postgres-XC has fed back ideas into PostgreSQL. > > Reviewed by Michael Paquier, Jeff Janes and Andres Freund > Performance testing by Jesper Pedersen
1 parent 639c3b2 commit 9b47607

File tree

3 files changed

+161
-221
lines changed

3 files changed

+161
-221
lines changed

0 commit comments

Comments
 (0)