Re: Replica string comparsion issue

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Replica string comparsion issue
Дата
Msg-id 7079.1528924388@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Replica string comparsion issue  (Andrey Lizenko <lizenko79@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Andrey Lizenko
Дата:
Сообщение: Re: Replica string comparsion issue
Следующее
От: Maksim Milyutin
Дата:
Сообщение: Re: Slow planning time for simple query