Re: Replica string comparsion issue - Mailing list pgsql-general

From Tom Lane
Subject Re: Replica string comparsion issue
Date
Msg-id 7079.1528924388@sss.pgh.pa.us
Whole thread Raw
In response to Re: Replica string comparsion issue  (Andrey Lizenko <lizenko79@gmail.com>)
List pgsql-general
Andrey Lizenko <lizenko79@gmail.com> 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


pgsql-general by date:

Previous
From: Andrey Lizenko
Date:
Subject: Re: Replica string comparsion issue
Next
From: Maksim Milyutin
Date:
Subject: Re: Slow planning time for simple query