[SoC2020] PostgreSQL: add io_uring support

[josephhz]

项目名称/Project Title

PostgreSQL: 增加 io_uring 支持 PostgreSQL: add io_uring support

项目描述/Project Description

PostgreSQL 是一款强大的开源对象-关系数据库服务器（ORDBMS），特点是可靠，特性健壮以及高性能，且支持跨平台。PostgreSQL 的 Slogan 是“世界上最先进的开源关系型数据库”，其官网链接：https://www.postgresql.org/

本项目计划在 PostgreSQL 中增加对 io_uring 的支持，以优化异步 io 模型的性能，目前社区也有在做这方面的尝试。参考资料：https://anarazel.de/talks/2020-01-31-fosdem-aio/aio.pdf

PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance. It supports running corss-platform. The slogan of PostgreSQL is "The World's Most Advanced Open Source Relational Database", as seen on the offical website is https://www.postgresql.org/.

This project wants to add io_uring support for PostgreSQL, to achieve better performance by using asynchronous io. Now community already has similar attempt, for more details please refer https://anarazel.de/talks/2020-01-31-fosdem-aio/aio.pdf

预期成果/Expected Outcomes

• 通过 PostgreSQL 自带回归测试用例
• 通过 pgTAP 测试套
• 支持 io_uring 的 PostgreSQL 版本在 Aliyun Linux 2 上能正常运行
• 预期相比原始版本性能有 10%+ 的提升

• Pass PostgreSQL related testcases
• Pass pgTAP testcases
• Make PostgreSQL with io_uring support run normally on Aliyun Linux 2
• Expect 10+ performance optimization compared to original version

需要的技能/Required Skills

• 熟悉 C 语言编程
• 熟悉 PostgreSQL 的基本原理机制
• 熟悉异步 IO（aio/io_uring）

• Familiar with C
• Familliar with PostgreSQL
• Familliar with aio/io_uring

[deepanshu1422]

@casparant @josephhz Sir, I would like to work upon this issue #9

[josephhz]

Thanks for taking interest on this project. Please apply it via our official website, which I described in the reply email.

[deepanshu1422]

@josephhz Thanks for your help and resolving the issues, I have submitted the same through the official form :)

[josephhz]

@josephhz Thanks for your help and resolving the issues, I have submitted the same through the official form :) You are welcome. Will announce the selected proposal according to timeline.