tsearch 2 query - Mailing list pgsql-general

From Matthew Terenzio
Subject tsearch 2 query
Date
Msg-id 852b23f40810020736k2ebec249n67bf1509dfe7e939@mail.gmail.com
Whole thread Raw
Responses Re: tsearch 2 query  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
There are less than 20,000 records being searched here, but the query takes several minutes.

I know this may not be enough info, but would one suggest I optimize the query or put my attention towards other areas.


SELECT id,date,headline as head,headline(body,q),rank(
vectors,q),timestamp FROM stories,to_tsquery('$query') AS q WHERE vectors @@ q ORDER BY $sort DESC OFFSET $offset LIMIT 20

pgsql-general by date:

Previous
From: Raul Carolus
Date:
Subject: Re: W2K8
Next
From: "Igor Neyman"
Date:
Subject: Re: That was easy