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

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

pgsql-performance by date

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

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