Andrey Lizenko <lizenko79@xxxxxxxxx> writes: > Another point regarding collations: query with ORDER BY returns different > record set on master and on replica if more than one column used: When I saw Peter's reply, I figured he'd nailed it, and this seems to be more evidence pointing in that direction. If the standby's OS sorts strings differently than the master does, the index will seem corrupt to it, even if it's fine on the master. regards, tom lane
