Gaini Rajeshwar writes:
> I am doing a fulltext search something like this:
> SELECT doc_id FROM docs WHERE tsv_title($$'magnetic induction'$$) OR
> tsv_body($$'magnetic induction'$$) OR tsv_abstract($$'abstract'$$)
Since you haven't told us what those functions do, we're just guessing.
But I wo
Also OR operator taking time.
--- On Wed, 21/10/09, Gaini Rajeshwar wrote:
From: Gaini Rajeshwar
Subject: [GENERAL] How to use Logical Operators in Fulltext Search?
To: "pgsql-general@postgresql.org mailing list"
Date: Wednesday, 21 October, 2009, 1:12 PM
Hi All,
I am doing
Can we have a explain plan SELECT doc_id FROM docs WHERE tsv_title($$'magnetic
induction'$$) OR
tsv_body($$'magnetic induction'$$) OR tsv_abstract($$'abstract'$$)
--
Thanks
Sam
--- On Wed, 21/10/09, Gaini Rajeshwar wrote:
From: Gaini Rajeshwar
Subject
Hi All,
I am doing a fulltext search something like this:
SELECT doc_id FROM docs WHERE tsv_title($$'magnetic induction'$$) OR
tsv_body($$'magnetic induction'$$) OR tsv_abstract($$'abstract'$$)
It is taking approximately 100 secs to execute.
But running the query on individual column something