Re: LIMIT not showing all results

From: Casey Deccio <casey(at)deccio(dot)net>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: LIMIT not showing all results
Date: 2019-03-05 18:41:08
Message-ID: 5188DC9C-9665-41E8-8B04-B016527321C4@deccio.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> On Mar 5, 2019, at 10:37 AM, Andreas Kretschmer <andreas(at)a-kretschmer(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2019-03-05 18:43:18 Re: [External] LIMIT not showing all results
Previous Message Matthew Pounsett 2019-03-05 18:09:28 Re: [External] LIMIT not showing all results