model-writtenrun 9255 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
Jun - Jul 2019 · 17 entries
- Julien Rouhaud proposed parallel reindexdb execution and a glibc-dependent index filter to reduce rebuilding time after collation-library upgrades, initially combining shared connection infrastructure, pointer lists, index scheduling, and filtering in #1.
- Michael Paquier questioned embedding per-table index scheduling in the shared connection machinery in #2, and Tom Lane proposed limiting parallelism to table-level operations to avoid index conflicts in #5.
- Álvaro Herrera requested a less generic infrastructure filename and proposed resumable processing in #4; Daniel Verite noted that ICU upgrades also change collations in #8, while Thomas Munro argued for libc rather than glibc terminology in #12.
- Peter Eisentraut argued that collation filtering belonged in backend REINDEX because dependency tracking would evolve in #16, and Julien agreed to pursue that separately in #26, replacing the original series with the simpler table-oriented patches in #27.
- Michael's API review in #29 led Julien to centralize connection/result handling and slot setup, acquisition, and completion in #32; Álvaro's review in #34 and Michael's follow-up in #42 led to clearer organization and uniform asynchronous handling in #43.
- Julien left special handling for explicitly requested catalog objects outside the patch because of its complexity in #43, then proposed silently serializing index requests even when other requested objects used multiple jobs in #44.
- Michael isolated and polished the infrastructure patch in #45, also identifying that the pending reindexdb code dispatched commands through the wrong connection; Julien reviewed the cleanup and questioned slot-memory ownership in #46.
- Michael committed the infrastructure from #45 as 5f3840370b, adding an assertion and leaving slot-memory freeing to the caller, then requested the remaining feature patch in #48.
- Julien submitted the remainder with corrected connection dispatch in #49, then responded to Michael's schema-parallelism review in #50 by expanding schemas into a shared table work list and adding tests in #51.
- Álvaro proposed using backend List infrastructure in frontend programs in #52, but Tom Lane objected to its memory-management assumptions and frontend constraints in #56, and Álvaro accepted that objection in #57.
- Álvaro supplied a small patch removing the remaining unnecessary vacuumdb progname parameter in #53, which Michael committed unchanged as 3cae75f420 and acknowledged in #58.
- Michael supplied test and documentation refinements in #59 and suggested representing database-wide work with the actual database name; Julien incorporated that suggestion and assertions in #60.
- Sergei Kornilov found that concurrent database reindexing failed on catalogs and that schema counts incorrectly limited worker counts in #61; Julien fixed both and added a regression test in #62, which Sergei tested successfully against older releases in #63.
- Michael argued for explicitly rejecting --index with multiple jobs in #64, while Julien preferred allowing mixed requests with serialized indexes in #66; Michael posted both alternatives as separable patches in #67, also correcting connection allocation and introducing exhaustive object-type switches.
- Sergei supported the explicit restriction in #70, and discussion between Julien and Michael in #68, #69, and #72 settled on keeping work-item counting simple rather than expanding the list API.
- Michael committed both parts of #67 as 5ab892c391, additionally fixing a double-free for empty work lists, testing an empty schema, and stopping counting once enough jobs were available, as reported in #73.
- The parallelism work was marked committed in #73 and acknowledged in #74; collation filtering had been deferred to separate backend work in #26, resumable processing remained unimplemented, and the final discussion moved to list representation and wider TOAST identifiers in #75, #76, #77, and #78.