Re: Full text search with ORDER BY performance issue - Mailing list pgsql-performance

Krade wrote:
> SELECT * FROM a WHERE comment_tsv @@ plainto_tsquery('love') ORDER BY
> timestamp DESC LIMIT 24 OFFSET 0;

Have you tried make the full-text condition in a subselect with "offset
0" to stop the plan reordering?

eg:

select *
from (
   select * from a where comment_tsv @@ plainto_tsquery('love')
   offset 0
) xx
order by timestamp DESC
limit 24
offset 0;


See http://blog.endpoint.com/2009/04/offset-0-ftw.html

--
-Devin