From: | Jeremy Ferrante <JFerrante(at)web(dot)com> |
---|---|
To: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | FullTextSearch - UNION individual indexes or concatenated columns index ? |
Date: | 2009-09-29 19:34:22 |
Message-ID: | 965AA5440EAC094E9F722519E285ACED01F177ABC3@WWCEXCHANGE.web.web.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2009-09-29 21:28:06 | Re: Speed while runnning large transactions. |
Previous Message | mange | 2009-09-29 19:13:55 | Performance RAID 0 |