Re: Bitmap and-ing between btree and gin?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Bitmap and-ing between btree and gin?
Дата
Msg-id 17855.1454602121@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Bitmap and-ing between btree and gin?  (Jordi <jmaillists@promani.be>)
Ответы Re: Bitmap and-ing between btree and gin?  (Jordi <jmaillists@promani.be>)
Список pgsql-performance
Jordi <jmaillists@promani.be> writes:
> I've been trying to get a query use indexes and it has raised a doubt
> whether pgsql supports bitmap and-ing between a multi-column btree index
> and a gin index.

Sure.  But such a plan would give an unordered result, meaning that we'd
have to process the whole table before doing the ORDER BY/LIMIT.  The
planner evidently thinks that it's better to try to process the rows in
ID order so it can stop as soon as it's got 100.  If it's wrong about
that, that's likely because it's got a bad estimate of the selectivity of
the other WHERE conditions.  You might see if you can improve the
statistics for the search_vector column.

            regards, tom lane


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

Предыдущее
От: Jordi
Дата:
Сообщение: Bitmap and-ing between btree and gin?
Следующее
От: Jordi
Дата:
Сообщение: Re: Bitmap and-ing between btree and gin?