Abstract: This paper explains the necessity of adopting ARIES algorithms to improve the performance of PostgreSQL by way of comparing the latter's recovery algorithms with ARIES algorithms. Based on analyzing current implementation strategy about recovery of PostgreSQL, some main data structures are designed and improved on the transaction recovery so that ARIES algorithms are adopted. This leads to improving the capability of PostgreSQL transaction processing in evidence.

Key words: ARIES algorithms；Transaction；Log；Savepoint；Checkpoint

摘要： 通过现有的PostgreSQL 的恢复算法和ARIES 算法的比较，说明采用ARIES 算法来改进PostgreSQL 的必要性，并在分析现有的PostgreSQL 与恢复相关的几个实现策略上，介绍为采用ARIES 算法而设计的主要数据结构以及如何改进事务恢复管理器以便支持ARIES算法的事务基本操作和恢复管理的实现流程。这样比较显著地提高了PostgreSQL 的事务处理能力。

关键词: ARIES 算法；事务；日志；保存点；检查点