Re: arrays and indexes

Поиск
Список
Период
Сортировка
От Pierre-Frédéric Caillaud
Тема Re: arrays and indexes
Дата
Msg-id opsbrh4nu4cq72hf@musicbox
обсуждение исходный текст
Ответ на Re: arrays and indexes  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
Список pgsql-performance
>> > SELECT * from content where 42 = ANY (authors);

>> Postgres does have a way to do what you ask, though. It involves GiST
>> indexes and the operators from the contrib/intarray directory from the
>> Postgres source.

    I have tried to use these indexes, and the performance was very good. It
can be faster (in fact much faster) than a join with an additional table,
because you don't have a join. The SQL array syntax is a pain, though.

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

Предыдущее
От: "Ross J. Reedstrom"
Дата:
Сообщение: Re: arrays and indexes
Следующее
От: Greg Stark
Дата:
Сообщение: Re: arrays and indexes