Re: [External] LIMIT not showing all results

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.

            regards, tom lane