Apr 2026

7 commits
Fix double-free in pg_stat_autovacuum_scores.
9 Apr 2026Nathan Bossartmaster19beta1REL_19_STABLE19beta1Also in: Fix "detected double pfree in PgStat Snapshot 0x557d9926b400" error (not this thread)
LLM analysis, 100% suremodified before commitlight changesfrom patchset #591 of 4 reviewers saw the final version

The eleven-file patch in #59 matches the commit except for a two-line comment rewording in src/backend/utils/activity/pgstat.c and commit-message edits; the Author trailer credits Sami Imseih. I disagree with the attribution in thread #139248: its source #1000669 predates this thread's matching April 9 patch, which implements the final may_free ownership API.

  • Alexander Lakhinsaw an earlier versionLLM analysis, 86% sureReported the reproducible double-free in the landed view in #36, prompting the ownership-API fix that followed.
  • Andres Freundsaw an earlier versionLLM analysis, 97% sureProposed the adopted may_free output parameter in #43, replacing the consistency-mode workaround in #39.
  • Tom Lanesaw an earlier versionLLM analysis, 97% sureArgued for explicit pgstat ownership guarantees and proposed an output-parameter solution in #44, before the substantial API rework.
  • Nathan Bossartsaw the final versioncommittercommitted the patch
Add LOG_NEVER error level code.
9 Apr 2026Nathan Bossartmaster19beta1REL_19_STABLE19beta1
LLM analysis, 100% surelanded as postedfrom patchset #491 of 1 reviewer saw the final version

Both hunks match #49: LOG_NEVER is defined in src/include/utils/elog.h and used by pg_stat_get_autovacuum_scores() in autovacuum.c.

  • Tom Lanesaw the final versionLLM analysis, 98% sureIdentified the undocumented zero log level in the view and specified the adopted LOG_NEVER definition in #46, followed only by this naming cleanup.
Add pg_stat_autovacuum_scores system view.
6 Apr 2026Nathan Bossartmaster19beta1REL_19_STABLE19beta1
LLM analysis, 100% surepart of a posted patchsetmoderate changesfrom patchset #331 of 4 reviewers saw the final version

Combines the view and boolean-extension patches from #33, excluding its separately committed prerequisite. Renames will_vacuum/will_analyze, revises documentation, bumps catversion, and changes pg_proc.dat from volatile/parallel-unsafe to stable/parallel-restricted.

  • Satyanarayana Narlapuramsaw an earlier versiontrailerTested the initial patches and raised interrupt, filtering, permissions, disabled-autovacuum, and standby concerns in #2 and #3, before substantial revisions.
  • Bharath Rupireddysaw an earlier versiontrailerReviewed the initial and refactored implementations in #4 and #17, discussing permissions, per-table access, allocation costs, documentation, and score computation before later redesigns.
  • Robert Treatsaw an earlier versiontrailerDiscussed MAINTAIN privileges and filtering in #7 and endorsed the revised view in #11, before access rules and boolean semantics changed.
  • Nathan Bossartsaw the final versioncommittercommitted the patch
Remove recheck_relation_needs_vacanalyze().
6 Apr 2026Nathan Bossartmaster19beta1REL_19_STABLE19beta1
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #330 of 1 reviewer saw the final version

Takes the first patch from #33, moving pgstat fetching/freeing into relation_needs_vacanalyze() and deleting its wrapper. Final edits remove a redundant null check and stale parameter documentation; the commit credits Sami and co-author Nathan.

  • Alvaro Herrerasaw an earlier versionLLM analysis, 99% sureIdentified duplicated stats-fetch/scoring calls and proposed eliminating recheck_relation_needs_vacanalyze() in #8, leading to the later refactoring.
Add elevel parameter to relation_needs_vacanalyze().
3 Apr 2026Nathan Bossartmaster19beta1REL_19_STABLE19beta1
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #251 of 1 reviewer saw the final version

Exactly matches the elevel component of #25 modulo diff positioning, adding the parameter and replacing DEBUG3 in the logging calls; the other four series components are excluded.

  • Nathan Bossartsaw the final versioncommittercommitted the patch
Teach relation_needs_vacanalyze() to always compute scores.
3 Apr 2026Nathan Bossartmaster19beta1REL_19_STABLE19beta1
LLM analysis, 100% surepart of a posted patchsetmoderate changesfrom patchset #251 of 2 reviewers saw the final version

Derives from the always-compute-scores component of #25, with local logic corrections moving vacuum, insert, and analyze score calculations outside threshold gates. It preserves the historical forced-vacuum analyze case while excluding the remaining series components.

  • Bharath Rupireddysaw an earlier versiontrailerReviewed the force_scores approach and challenged its branching and disabled-autovacuum behavior in #17, before unconditional computation and subsequent logic corrections.
  • Nathan Bossartsaw the final versioncommittercommitted the patch
Refactor relation_needs_vacanalyze().
3 Apr 2026Nathan Bossartmaster19beta1REL_19_STABLE19beta1
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #251 of 1 reviewer saw the final version

Exactly matches the first component of #25: adds an early return and removes one indentation level in relation_needs_vacanalyze(); the other four components landed separately or were revised.

  • Sami Imseihsaw the final versiontrailerExplicitly welcomed the prerequisite refactoring in #26, and the commit carries his Reviewed-by credit for the unchanged component.

Credits across 7 commits

Author
Sami Imseih5
Nathan BossartLLM2
Reviewer
Nathan Bossartcommitter4
Bharath Rupireddy2
Robert Treat1
Sami Imseih1
SATYANARAYANA NARLAPURAM1
Reported by
Alexander Lakhin1
Tender Wang1
Co author
Nathan Bossart1
Committer
Nathan Bossart7

N LLM means N of the credits come from LLM analysis, not from commit trailers.