Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx> writes: > On Apr 5, 2025, at 9:18 AM, Laurenz Albe <laurenz.albe@xxxxxxxxxxx> wrote: >> Also, compare the collations shown in the \l output for the database. > And glibc versions... Yeah, that. This smells very much like a collation-inconsistency problem: random punctuation is exactly the sort of input that the glibc authors tend to change collation behaviors for. I'm betting that at some point the problematic database was physically copied between two platforms with inconsistent collations. (The OP mentioning use of two different Linux distros bolsters this theory.) That made the index inconsistent with the new platform's sorting behavior, and weird key lookup failures is exactly what you get as a result of that. Short answer: REINDEX whatever index the problematic query is using, as well as any others on text columns, because they likely have similar issues you haven't noticed yet. regards, tom lane
