- Notifications
You must be signed in to change notification settings - Fork28
Commit978b2f6
committed
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 atCOMMIT PREPARED/ABORT PREPARED. Prepared transactions that live past one bufmgrcheckpoint cycle will be written to disk in the same form as previously. Crashrecovery path is not altered. Measured performance gains of 50-100% for short2PC transactions by completely avoiding writing files and fsyncing. Otheroptimizations still available, further patches in related areas expected.Stas Kelvich and heavily edited by Simon RiggsBased 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 FreundPerformance testing by Jesper Pedersen1 parentd0f2f53 commit978b2f6
File tree
3 files changed
+160
-221
lines changed- src
- backend/access/transam
- include/access
3 files changed
+160
-221
lines changed0 commit comments
Comments
(0)