Postgres Pro
Downloads
Home   >   mailing lists

Re: [External] LIMIT not showing all results - Mailing list pgsql-general

From Matthew Pounsett
Subject Re: [External] LIMIT not showing all results
Date
Msg-id CAAiTEH9E9+q8YO8WMVMtqP5MwxFaJ+spUhYCVSBXcS4E-XacPQ@mail.gmail.com
Whole thread Raw
In response to Re: [External] LIMIT not showing all results  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses 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>)
List pgsql-general
Tree view


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 by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: [External] LIMIT not showing all results
Next
From: Casey Deccio
Date:
Subject: Re: LIMIT not showing all results