On 06/06/21 11:08, Omar Kilani wrote: > I'm running pg_verify_checksums on the cluster, but the database is > many TB so it'll be a bit.
Index corruption because of a locale change would not be the sort of thing checksums would detect. Entries would be put into the index in the correct order according to the old collation. The same entries can be still there, intact, just fine according to the checksums, only the new collation would have put them in a different order. Index search algorithms that are fast, because they assume the entries to be correctly ordered, will skip regions of the index where the desired key "couldn't possibly be", and if that's where the old ordering put it, it won't be found. Regards, -Chap
