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: (view raw, whole thread or download thread mbox)
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
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,

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.


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-2017 The PostgreSQL Global Development Group