Re: EXPLAIN ANALYZE of BRIN bitmap index scan with disjunction

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: EXPLAIN ANALYZE of BRIN bitmap index scan with disjunction
Дата
Msg-id CANP8+j++Vhbwh1V0hxrA_jeMzxuzzFh833-ere-iuob0KDE=Wg@mail.gmail.com
обсуждение исходный текст
Ответ на RE: EXPLAIN ANALYZE of BRIN bitmap index scan with disjunction  (Chris Wilson <chris.wilson@cantabcapital.com>)
Ответы Re: EXPLAIN ANALYZE of BRIN bitmap index scan with disjunction
Список pgsql-performance
Дерево обсуждения
On Thu, 20 Jun 2019 at 17:01, Chris Wilson <chris.wilson@cantabcapital.com> wrote:
 

I deliberately included r in the index, to demonstrate the issue that I’m seeing. I know that there is very little locality in this particular, dummy, arbitrary test case. I can try to produce a test case that has some locality, but I expect it to show exactly the same results, i.e. that the BRIN index performs much worse when we try to query on this column as well.


I'm suggesting that adding the second column to the index is the source of your problem, not adding the column to the query.

How does it perform with just the id column in the index? 

--
Simon Riggs                http://www.2ndQuadrant.com/
PostgreSQL Solutions for the Enterprise

В списке pgsql-performance по дате отправления:

Предыдущее
От: Chris Wilson
Дата:
Сообщение: RE: EXPLAIN ANALYZE of BRIN bitmap index scan with disjunction
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: EXPLAIN ANALYZE of BRIN bitmap index scan with disjunction