Gaini Rajeshwar <raja.rajeshwar2006@xxxxxxxxx> 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 would suggest that if you can use | within a single tsquery, it'll probably run faster. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
