Re: allow disabling indexscans without disabling bitmapscans

Поиск
Список
Период
Сортировка
От Justin Pryzby
Тема Re: allow disabling indexscans without disabling bitmapscans
Дата
Msg-id 20200104193416.GX12066@telsasoft.com
обсуждение исходный текст
Ответ на allow disabling indexscans without disabling bitmapscans  (Justin Pryzby <pryzby@telsasoft.com>)
Список 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 по дате отправления:

Предыдущее
От: Dean Rasheed
Дата:
Сообщение: Re: Greatest Common Divisor
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pgsql: Add basic TAP tests for psql's tab-completion logic.