Re: Replica string comparsion issue

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrey Lizenko <lizenko79(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Replica string comparsion issue
Date: 2018-06-13 21:13:08
Message-ID: 7079.1528924388@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andrey Lizenko <lizenko79(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Maksim Milyutin 2018-06-13 23:04:26 Re: Slow planning time for simple query
Previous Message Andrey Lizenko 2018-06-13 21:03:11 Re: Replica string comparsion issue