[fulltext] GIN indexes - OR search

From: esemba <esemba(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: [fulltext] GIN indexes - OR search
Date: 2009-03-30 12:13:20
Message-ID: 22781900.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Is it possible to have 2 gin indexes and OR the search of them?
Problem is, I need to search 5 columns and there is limitation of only 4
weights, so I want to have one index of 4 vectors and second index of 1
vector and need to OR the search.
When I try to search them separately, or use AND, it works, but for OR
EXPLAIN ANALYZE shows me, it does seq scan.

Thank you.
--
View this message in context: http://www.nabble.com/-fulltext--GIN-indexes---OR-search-tp22781900p22781900.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2009-03-30 12:28:30 Re: New shapshot RPMs (Mar 27, 2009) are ready for testing
Previous Message Thomas Kellerer 2009-03-30 12:06:27 Re: New shapshot RPMs (Mar 27, 2009) are ready for testing