Search Postgresql Archives

Re: [External] LIMIT not showing all results

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Tue, 5 Mar 2019 at 12:54, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Andreas Kretschmer <andreas@xxxxxxxxxxxxxxx> 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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux