Re: allow disabling indexscans without disabling bitmapscans - Mailing list pgsql-hackers

From Justin Pryzby
Subject Re: allow disabling indexscans without disabling bitmapscans
Date
Msg-id 20200104193416.GX12066@telsasoft.com
Whole thread Raw
In response to allow disabling indexscans without disabling bitmapscans  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-hackers
On Sat, Jan 04, 2020 at 10:50:47AM -0600, Justin Pryzby wrote:
> > Doesn't enable_indexscan=off accomplish this already?  It is possible but
> > not terribly likely to switch from index to seq, rather than from index to
> > bitmap.  (Unless the index scan was being used to obtain an ordered result,
> > but a hypothetical enable_bitmapscan=FORCE can't fix that).
> 
> No, enable_indexscan=off implicitly disables bitmap index scans, since it does:

I don't know how I went wrong, but the regress tests clued me in..it's as Jeff
said.

Sorry for the noise.

Justin



pgsql-hackers by date:

Previous
From: Dean Rasheed
Date:
Subject: Re: Greatest Common Divisor
Next
From: Tom Lane
Date:
Subject: Re: pgsql: Add basic TAP tests for psql's tab-completion logic.