GSoC 2022 Final Report - PostgreSQL

Intro

• I worked with PostgreSQL project in Google Summer of Code 2022 this summer.

• I tried to improve test coverage for various modules.

Goal

• My Goal is to improve the test coverage of PostgreSQL, as indicated in the postgres wiki - gsoc 2022 document.

• Here is my Proposal Improve PostgreSQL Regression Test Coverage - DongWook Lee

• My original goal was to increase the test coverage of the modules below.

- pg_dump
- psql
- pg_ctl
- initdb
- pg_stat_statments
- pg_buffercache
- pg_prewarm
- pgrowlocks
- pgstattuple
- pg_waldump
- pg_basebackup

• Except for pg_dump, pg_ctl, initdb, and pg_stat_statments, I attempted all to improve test coverage, and several succeeded.

Coverage Result

pgrowlocks

Before After

• Improve coverage 0% to 90.7%

pg_prewram

Before After

• Improve coverage 11.6% to 77.3%

pg_buffercache

Before After

• Improve coverage 0% to 97.6%

Commitfest

• pg_prewarm add configuration example
• pg_buffercache: add sql test
• Add test of pg_prewarm extension
• Add TAP test for auth_delay extension
• old_snapshot: add test for coverage
• pg_waldump: add test for coverage
• pg_basebackup: add test about zstd compress option
• pgstattuple: add test for coverage
• xml2: add test for coverage
• pg_checksum: add test for coverage
• add test: pg_rowlocks extension
• vacuumlo: add test to vacuumlo for test coverage

Patch Series

• Add a regression test for contrib/pgrowlocks
• Add a regression test for contrib/pg_prewarm
• Add regression test coverage for contrib/pg_buffercache
• doc: add pg_prewarm example