arXivDaily arXiv每日学术速递 周一至周五更新
arXiv周末暂无论文更新,休息一下吧,周末愉快~~
arXiv 1208.4179cs.DB
收藏

PostgreSQL中的可串行化快照隔离

Serializable Snapshot Isolation in PostgreSQL

Dan R. K. Ports, Kevin Grittner

摘要:

本文描述了我们实现PostgreSQL新的可序列化隔离级别的经验。它基于最近开发的可串行快照隔离(SSI)技术。这是SSI在生产数据库版本中的第一个实现,也是在以前没有基于锁的可序列化隔离级别的数据库中的第一个实现。我们反思了我们的经验,并描述了我们如何克服由此产生的一些挑战,包括实现新的锁管理器、确保内存使用有限制的技术,以及与其他PostgreSQL功能的集成。我们还引入了SSI的扩展,以提高只读事务的性能。我们使用几个基准测试评估PostgreSQL的可序列化隔离级别,并表明它实现的性能仅略低于快照隔离,并显着优于传统的两阶段锁定方法的读密集型工作负载。

英文摘要:

This paper describes our experience implementing PostgreSQL's new serializable isolation level. It is based on the recently-developed Serializable Snapshot Isolation (SSI) technique. This is the first implementation of SSI in a production database release as well as the first in a database that did not previously have a lock-based serializable isolation level. We reflect on our experience and describe how we overcame some of the resulting challenges, including the implementation of a new lock manager, a technique for ensuring memory usage is bounded, and integration with other PostgreSQL features. We also introduce an extension to SSI that improves performance for read-only transactions. We evaluate PostgreSQL's serializable isolation level using several benchmarks and show that it achieves performance only slightly below that of snapshot isolation, and significantly outperforms the traditional two-phase locking approach on read-intensive workloads.

机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。

↑