Re: Peter Eisentraut 2018-09-13 <[email protected]> > Moreover, the fix for a collation version mismatch is, in the simplest > case, to go around and REINDEX everything. Making the collation or > collation version global doesn't fix that. It would actually make it > harder because you couldn't run ALTER COLLATION REFRESH VERSION until > after you have rebuilt all affected objects *in all databases*.
Btw, I think a "reindexdb --all --collation" (and the SQL per-database equivalent) that only rebuilds indexes that are affected by collations would be immensely useful to have. Christoph
