Обсуждение: FullTextSearch - UNION individual indexes or concatenated columns index ?

Поиск
Список
Период
Сортировка

FullTextSearch - UNION individual indexes or concatenated columns index ?

От
Jeremy Ferrante
Дата:

I’m attempting to implement full-text search and am torn between two techniques:

 

1) Create multiple GIN indexes on columns I’m going to search against and UNION the results

or

2) Create one concatenated column GIN index consisting of the columns that will be searched.

 

Is there any performance considerations that may make one technique better than the other?

 

Thanks for insight,

Jer


Attention:
The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any system and destroy any copies.

Re: FullTextSearch - UNION individual indexes or concatenated columns index ?

От
Josh Berkus
Дата:
Jeremy,

> Is there any performance considerations that may make one technique
> better than the other?

(2) will me much faster.  Assuming you're searching all columns, of course.


--
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com

Сайт использует файлы cookie для корректной работы и повышения удобства. Нажимая кнопку «Принять» или продолжая пользоваться сайтом, вы соглашаетесь на их использование в соответствии с Политикой в отношении обработки cookie ООО «ППГ», в том числе на передачу данных из файлов cookie сторонним статистическим и рекламным службам. Вы можете управлять настройками cookie через параметры вашего браузера