Re: [fulltext] GIN indexes - OR search

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: esemba <esemba(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [fulltext] GIN indexes - OR search
Date: 2009-03-30 13:53:10
Message-ID: 2590.1238421190@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

esemba <esemba(at)gmail(dot)com> writes:
> Is it possible to have 2 gin indexes and OR the search of them?

Sure. They need to be fairly restrictive though, or the planner might
decide that a seqscan is cheaper.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2009-03-30 13:56:03 Re: Installing PLPython - Version Problem
Previous Message ray 2009-03-30 13:28:20 Re: Installing PLPython - Version Problem