Quality Assurance in PostgreSQL
summary
PostgreSQL quality assurance combines process controls—commitfests, mandatory code review and proofs-of-concept for risky patches—with two layers of automated testing: about 170 SQL test files plus a Perl regression harness and community Python tools. Performance validation uses pgb-like benchmarks, Linux perf and flamegraphs (an example: fixing nested-loop lookups on a 10,000-partition case produced over a 2× speedup), while memory bugs are found with ASAN/valgrind and static analysis; test coverage is reported at roughly 72% line coverage and 81% function coverage.
AI-written summary · about
chapters (11)
- 0:00PostgreSQL quality intro
- 2:09Project structure
- 5:24Patch development
- 8:57Testing methods
- 12:29Code and docs
- 15:45Performance testing
- 17:51Debugging tools
- 21:07Performance example
- 23:57Static analysis
- 24:42Learn and contribute
- 26:26Q&A
