nickr(at)mirth(dot)com writes:
> It would appear that when you order on a column such that the query plan
> scans across a composite, multi-type index (say, bigint and integer), and
> the plan runs through an Index Cond, doing all that AND a LIMIT clause no
> longer works. And by "no longer works" I mean the query does not return any
> results when it should.
I failed to reproduce any such problem in a little bit of trying. Can you
create a self-contained test case?
The symptoms seem consistent with the theory that that index is corrupt
... have you tried REINDEXing it?
regards, tom lane