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

From Casey Deccio
Subject Re: LIMIT not showing all results
Date
Msg-id 5188DC9C-9665-41E8-8B04-B016527321C4@deccio.net
Whole thread Raw
In response to Re: [External] LIMIT not showing all results  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Responses Re: LIMIT not showing all results  (Andreas Kretschmer <andreas@a-kretschmer.de>)
List pgsql-general

On Mar 5, 2019, at 10:37 AM, Andreas Kretschmer <andreas@a-kretschmer.de> wrote:

no, but you can set enable_indexscan to off and maybe also enable_bitmapscan to off to force the planner to choose a seq-scan.
I'm sure in this case you will get a correct result.

So this (setting enable_indexscan to off) might be a short-term fix, while reindexing is the more robust fix?

Casey

pgsql-general by date:

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