Re: Queryplan within FTS/GIN index -search.

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: Queryplan within FTS/GIN index -search.
Дата
Msg-id 1256325723.28858.60.camel@monkey-cat.sm.truviso.com
обсуждение исходный текст
Ответ на Re: Queryplan within FTS/GIN index -search.  (Richard Huxton <dev@archonet.com>)
Список pgsql-performance
On Fri, 2009-10-23 at 17:27 +0100, Richard Huxton wrote:
> Returns an array of keys given a value to be queried; that is, query is
> the value on the right-hand side of an indexable operator whose
> left-hand side is the indexed column
>
> So - that is presumably two separate arrays of keys being matched
> against, and the AND means if the first fails it'll never check the second.

My point was that if it's only one index scan in both cases, then GIN
should have the same information in both cases, right? So why are they
being treated differently?

I must be missing something.

Regards,
    Jeff Davis


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

Предыдущее
От: Kevin Buckham
Дата:
Сообщение: Re: Table Clustering & Time Range Queries
Следующее
От: Jesper Krogh
Дата:
Сообщение: Re: Calculating selectivity for the query-planner on ts_vector colums.