pgconfig / api / 21692241231

37%

master: 79%

Pull #35

github

feat: optimize random_page_cost for DW analytical workloads

Set random_page_cost to 1.8 for DW profile on SSD/SAN storage,
as analytical queries often touch >10% of rows where sequential
scans are more efficient than index scans. Other profiles maintain
1.1 for SSD to favor index scans.

Add comprehensive table-driven tests covering all profile and
storage combinations. Update documentation with 2025 debate on
plan stability vs SSD optimization, and guidance on when
sequential scans become more efficient.

Signed-off-by: Sebastian Webber <sebastian@swebber.me>

55 of 55 new or added lines in 3 files covered. (100.0%)

402 of 1133 relevant lines covered (35.48%)

7.28 hits per line