Content-Length: 243622 | pFad | https://github.com/postgrespro/postgres/commit/978b2f65aa1262eb4ecbf8b3785cb1b9cf4db78e

51 Speedup 2PC by skipping two phase state files in normal path · postgrespro/postgres@978b2f6 · GitHub
Skip to content

Commit 978b2f6

Browse files
simonat2ndQuadrantsimonat2ndQuadrant
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 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 d0f2f53 commit 978b2f6

File tree

3 files changed

+160
-221
lines changed

3 files changed

+160
-221
lines changed

0 commit comments

Comments
 (0)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: https://github.com/postgrespro/postgres/commit/978b2f65aa1262eb4ecbf8b3785cb1b9cf4db78e

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy