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, andpg_stat_statments, I attempted all to improve test coverage, and several succeeded.
Coverage Result
pgrowlocks
Before
After
- Improve coverage
0%to90.7%
pg_prewram
Before
After
- Improve coverage
11.6%to77.3%
pg_buffercache
Before
After
- Improve coverage
0%to97.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