model-writtenrun 9829 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Tom Lane posted #1 after work on making the name type collatable exposed broken statistics, proposing per-slot collation storage in pg_statistic to avoid extra catalog lookups and leave room for statistics under multiple collations.
- The draft in #1 updated ANALYZE and selectivity functions but left extended statistics, array selectivity comparisons, interaction with Peter Eisentraut's collation work, and a temporary default-collation fallback as loose ends.
- Peter Eisentraut supported the design and reported manageable interactions with his own patch in #2, favoring Tom's patch landing first; Tom committed to investigating the remaining issues before pushing in #3.
- Peter Eisentraut identified that expression-index statistics should honor the index's collation override in #4, and Tom agreed to implement that change in the thread's final message, #5.
- Tom subsequently committed #1 as 5e09280057, adding the index-collation fix and type-default collation handling for arrays and extended statistics; the temporary fallback remained, and accurate estimates for explicit COLLATE clauses differing from the stored statistics remained future work.