Re: FullTextSearch - UNION individual indexes or concatenated columns index ?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Jeremy Ferrante <JFerrante(at)web(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: FullTextSearch - UNION individual indexes or concatenated columns index ?
Date: 2009-09-29 22:58:59
Message-ID: 4AC29133.1060608@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Ivan Voras 2009-09-30 13:20:36 Re: Bad performance of SELECT ... where id IN (...)
Previous Message Robert Haas 2009-09-29 21:28:06 Re: Speed while runnning large transactions.