May 2021

1 commit
Describe (auto-)analyze behavior for partitioned tables
14 May 2021Alvaro Herreramaster14beta1REL_19_STABLE14beta1REL_18_STABLE14beta1REL_17_STABLE14beta1REL_16_STABLE14beta1REL_15_STABLE14beta1REL_14_STABLE14beta1
LLM analysis, 100% suremodified before commitlight changesfrom patchset #31

The commit retains all four documentation files from #31, incorporating #32's corrections about deletes, recursive analysis, inheritance statistics and restoring parent statistics. Its Author trailers credit Justin Pryzby and Alvaro Herrera, and #33 confirms these corrections and minor additional edits were pushed.

Apr 2021

2 commits
Add comment about extract_autovac_opts not holding lock
21 Apr 2021Alvaro Herreramaster14beta1REL_19_STABLE14beta1REL_18_STABLE14beta1REL_17_STABLE14beta1REL_16_STABLE14beta1REL_15_STABLE14beta1REL_14_STABLE14beta1
LLM analysis, 100% surewritten from the discussion, no matching patch

The sole change adds a five-line comment above extract_autovac_opts in src/backend/postmaster/autovacuum.c explaining why unlocked reloptions access is safe without a pg_class TOAST table. Tom Lane requested that explanation in #4, and Alvaro confirmed adding it in #23; no attached patch contains it.

Set pg_class.reltuples for partitioned tables
9 Apr 2021Alvaro Herreramaster14beta1REL_19_STABLE14beta1REL_18_STABLE14beta1REL_17_STABLE14beta1REL_16_STABLE14beta1REL_15_STABLE14beta1REL_14_STABLE14beta1
LLM analysis, 100% suremodified before commitlight changesfrom patchset #71 of 1 reviewer saw the final version

The commit preserves #7's changes to analyze.c, tablecmds.c and autovacuum.c, with a small equivalent cleanup in truncate_update_partedrel_stats: removing the redundant dirty flag, merging conditionals, narrowing variable scope and explicitly casting zero. Zhihong Yu requested the conditional cleanup in #8, and Alvaro accepted it in #9.

  • Zhihong Yusaw the final versiontrailerIn #8, Zhihong Yu reviewed #7 and proposed removing the redundant dirty flag and merging its conditionals, which the committed version does.

Credits across 3 commits

Author
Alvaro Herrera2
Justin Pryzby1
Reviewer
Zhihong Yu1
Committer
Alvaro Herrera3