Postgres Pro
Downloads
Home   >   mailing lists

Re: FullTextSearch - UNION individual indexes or concatenated columns index ? - Mailing list pgsql-performance

From Josh Berkus
Subject Re: FullTextSearch - UNION individual indexes or concatenated columns index ?
Date
Msg-id 4AC29133.1060608@agliodbs.com
Whole thread Raw
In response to FullTextSearch - UNION individual indexes or concatenated columns index ?  (Jeremy Ferrante <JFerrante@web.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: Speed while runnning large transactions.
Next
From: Ivan Voras
Date:
Subject: Re: Bad performance of SELECT ... where id IN (...)