FullTextSearch - UNION individual indexes or concatenated columns index ?

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.

Responses

Browse pgsql-performance by date

  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