Re: [External] LIMIT not showing all results

Поиск
Список
Период
Сортировка
От Matthew Pounsett
Тема Re: [External] LIMIT not showing all results
Дата
Msg-id CAAiTEH9E9+q8YO8WMVMtqP5MwxFaJ+spUhYCVSBXcS4E-XacPQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [External] LIMIT not showing all results  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [External] LIMIT not showing all results  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Re: [External] LIMIT not showing all results  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general


On Tue, 5 Mar 2019 at 12:54, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Andreas Kretschmer <andreas@a-kretschmer.de> writes:
> the other thing is, it would be nice to to know why the index is corrupt.

Given that (a) this was triggered by a server migration and (b)
the leading column of the index looks like it's probably varchar,
I'm suspicious that the new server has different collation behavior.

The migration in question was an rsync from a Debian 9 box running 9.4.19-0+deb8u1 to a FreeBSD 11 box  running 9.4.20.

В списке pgsql-general по дате отправления:

Предыдущее
От: Andreas Kretschmer
Дата:
Сообщение: Re: [External] LIMIT not showing all results
Следующее
От: Casey Deccio
Дата:
Сообщение: Re: LIMIT not showing all results