tsearch2 query - Mailing list pgsql-general

From Matthew Terenzio
Subject tsearch2 query
Date
Msg-id 852b23f40810020728y435254a7h370619640590020d@mail.gmail.com
Whole thread Raw
Responses Re: tsearch2 query  (Oleg Bartunov <oleg@sai.msu.su>)
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: Reg Me Please
Date:
Subject: Re: Transactions within a function body
Next
From: Raul Carolus
Date:
Subject: Re: W2K8