Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Robert HaasDate: 2009-09-29 21:28:06
Subject: Re: Speed while runnning large transactions.
Previous:From: mangeDate: 2009-09-29 19:13:55
Subject: Performance RAID 0

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group