Apr 2025

2 commits
Give up on running with NetBSD/OpenBSD's default semaphore settings.
29 Apr 2025Tom Lanemaster18beta1REL_19_STABLE18beta1REL_18_STABLE18beta1Also in: pgsql: aio: Infrastructure for io_method=worker (not this thread)
LLM analysis, 100% surewritten from the discussion, no matching patch1 of 1 reviewer saw the final version

Implements Tom Lane's revised proposal in #68: restore SEMAS_PER_SET to 16 and the minimum trial connection count to 20 while retaining adaptive autovacuum slots. No attachment contains this change; #70 confirms the commit and additional runtime.sgml corrections.

  • Nathan Bossartsaw the final versiontrailerNathan endorsed the revised approach before commitment in #69, checking that the smallest derived slot count would remain at least three; there was no attached revert patch.
initdb: Do not report default autovacuum_worker_slots.
29 Apr 2025Nathan Bossartmaster18beta1REL_19_STABLE18beta1REL_18_STABLE18beta1
LLM analysis, 100% surewritten from the discussion, no matching patch2 of 2 reviewers saw the final version

Deletes the seven-line autovacuum_worker_slots progress-report block in src/bin/initdb/initdb.c following Peter Eisentraut's report #61 and Tom Lane's removal proposal #62. No attached patch proposes this deletion, and #65 announces commitment.

  • Peter Eisentrautsaw the final versionLLM analysis, 100% surePeter reported the misleading progress output in #61 and explicitly accepted its removal in #64 before commitment.
  • Tom Lanesaw the final versionLLM analysis, 100% sureTom proposed removing the derived slot-count report in #62, which is the exact change committed.

Jan 2025

2 commits
Lower default value of autovacuum_worker_slots in initdb as needed.
7 Jan 2025Nathan Bossartmaster18beta1REL_19_STABLE18beta1REL_18_STABLE18beta1
LLM analysis, 100% suremodified before commitlight changesfrom patchset #581 of 1 reviewer saw the final version

Matches #58 in doc/src/sgml/config.sgml and src/bin/initdb/initdb.c except for correcting autovacuum_worker_slot's to autovacuum_worker_slots's in the formula comment. The max_connections / 6 logic is unchanged.

  • Tom Lanesaw the final versiontrailerTom rejected extra initdb probes in #55, proposed division by six while approving the revised algorithm in #57, and accepted the final attachment in #59.
Allow changing autovacuum_max_workers without restarting.
6 Jan 2025Nathan Bossartmaster18beta1REL_19_STABLE18beta1REL_18_STABLE18beta1
LLM analysis, 100% surelanded as postedfrom patchset #470 of 5 reviewers saw the final version

The complete eleven-file diff matches #47, including the PGC_SIGHUP change, counted worker freelist, startup/reload warnings, and TAP slot setting. Nathan confirms commitment in #48.

  • Sami Imseihsaw an earlier versiontrailerSami tested dynamic worker counts and cost balancing, reviewed documentation and limits in #7, #18, #22, and #27, before subsequent capacity-design and warning changes.
  • Justin Pryzbysaw an earlier versiontrailerJustin examined the two-limit proposal and suggested an alternative policy-GUC interface in #13, before the later capacity experiments and warning implementation.
  • Robert Haassaw an earlier versiontrailerRobert evaluated worker-count defaults, cost balancing, and scheduling limitations in #20, before the subsequent design revisions.
  • Andres Freundsaw an earlier versiontrailerAndres identified lock-table and TAP memory costs in #30 and #34 and proposed connection-dependent capacity in #36, before the final configurable-pool implementation.
  • Yogesh Sharmasaw an earlier versiontrailerYogesh reported expected worker behavior and warning output in #45, despite contradictory form flags, before #46 changed startup-warning placement and conditions.

Credits across 4 commits

Author
Nathan BossartLLM2
Tom Lane1
Reviewer
Andres Freund1
Justin Pryzby1
Nathan Bossart1
Robert Haas1
Sami Imseih1
Tom Lane1
Yogesh Sharma1
Reported by
Peter Eisentraut1
Tom Lane1
Committer
Nathan Bossart3
Tom Lane1

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