PostgreSQL Bug Reports One new pgsql-bugs thread per report: BUG # web-form submissions stacked with free-form emails (about a third of reports); line = 6-month average of bothBug Reports per MonthOne new pgsql-bugs thread per report: BUG # web-form submissions stacked with free-form emails (about a third of reports); line = 6-month average of bothSeriesfree-form reportsBUG # form reports6-month averageJul2020OctJan2021AprJulOctJan2022AprJulOctJan2023AprJulOctJan2024AprJulOctJan2025AprJulOctJan2026AprJul020406080100New pgsql-bugs threads, form + free-form; complete weeks only, last three rolling months, with a trailing 3-week average of bothBug Reports per WeekNew pgsql-bugs threads, form + free-form; complete weeks only, last three rolling months, with a trailing 3-week average of bothSeriesfree-form reportsBUG # form reports3-week average27Jul'263Aug101724317Sep1421285Oct121905101520All reports (form + free-form). Bars: reports later linked to a fix commit (count, left axis). Lines: acted-upon share (right axis) with its 3-month rolling average. Lower bound (exact links only); trailing months right-censoredBug Reports Acted Upon, by MonthAll reports (form + free-form). Bars: reports later linked to a fix commit (count, left axis). Lines: acted-upon share (right axis) with its 3-month rolling average. Lower bound (exact links only); trailing monthsright-censoredReports acted uponActed upon (%)3 month rolling averageJul2020OctJan2021AprJulOctJan2022AprJulOctJan2023AprJulOctJan2024AprJulOctJan2025AprJulOctJan2026AprJul0102030Reports acted upon0.0%10.0%20.0%30.0%40.0%50.0%acted upon (%)0.0%10.0%20.0%30.0%40.0%50.0%acted upon (%) Avg distinct backpatched fixes per cycle — full-cycle totals are ~flat; the early window is notFix Submission by Release Quarter: First 20 Days vs Full CycleAvg distinct backpatched fixes per cycle — full-cycle totals are ~flat; the early window is notfirst 20 daysfull cycleFebMayAugNov050100150Share of the cycle's fixes committed in the first 20 days — Feb/May front-load, Aug/Nov back-loadFront-Loading by Release QuarterShare of the cycle's fixes committed in the first 20 days — Feb/May front-load, Aug/Nov back-loadFebMayAugNov0.0%10.0%20.0% All bug reports (form + free-form); roughly one in four ends up linked to a fix commitReport Outcomes per YearAll bug reports (form + free-form); roughly one in four ends up linked to a fix commitlinked to a fix commitno linked commit20202021202220232024202520260200400Acted-upon reports only, form + free-formMedian Report-to-Fix Latency per YearActed-upon reports only, form + free-formmedian days to commit20202021202220232024202520260246 All bug reports; days from report to its first linked commit -- most fixes land within a weekHow Fast Fixes LandAll bug reports; days from report to its first linked commit -- most fixes land within a weekacted-upon reports01002001: same/next day2: within a week3: within a month4: within 6 months5: longerAll bug reports; reports that get fixed draw longer threadsDiscussion Volume by OutcomeAll bug reports; reports that get fixed draw longer threadslinked to a fix commitno linked commit05001,0001,5001: no replies2: 2-3 messages3: 4-10 messages4: 11+ messages Most-Discussed Bug ReportsReportedKindMessagesOutcomeDays to fixSubject19 Dec 2020free-form147fixed42CREATE INDEX CONCURRENTLY does not index prepared xact's data29 Oct 2021BUG # form105fixed994BUG #17257: (auto)vacuum hangs within lazy_scan_prune()24 Oct 2021BUG # form103fixed3BUG #17245: Index corruption involving deduplicated entries16 Mar 2024free-form96fixed10Regression tests fail with musl libc because libpq.so can't be loaded19 May 2025free-form94fixed29Logical replication 'invalid memory alloc request size 1585837200' after upgrading to 17.529 Oct 2021BUG # form90fixed77BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum11 May 2023BUG # form86fixed124BUG #17928: Standby fails to decode WAL on termination of primary2 Oct 2021BUG # form83fixed10BUG #17212: pg_amcheck fails on checking temporary relations18 May 2022BUG # form80fixed13BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY1 Jun 2020free-form77fixed10Potential G2-item cycles under serializable isolation16 Nov 2024BUG # form67fixed26BUG #18711: Attempting a connection with a database name longer than 63 characters now fai14 Jul 2022free-form61fixed47Excessive number of replication slots for 12->14 logical replication15 May 2025free-form54-—Postgres: Queries are too slow after upgrading to PG17 from PG1529 Sep 2020BUG # form51fixed15BUG #16643: PG13 - Logical replication - initial startup never finishes and gets stuck in 23 Aug 2022free-form50fixed815pg_rewind WAL segments deletion pitfall Data as of 21:42 UTC on 26 Oct 2026 made withdbt Charts