Re: Full text search with ORDER BY performance issue

[Devin Ben-Hur <dbenhur@xxxxxxxxxxxxxx>]

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

--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance