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

On Sun, Jul 19, 2009 at 12:07 AM, Krade<krade@krade.com> wrote:
> archive=> explain analyze select * from a where  comment_tsv @@
> plainto_tsquery('love') order by timestamp desc limit 24 offset 0;

What happens if you make it:


select * from (
        select * from a where  comment_tsv @@plainto_tsquery('love')
) xx

order by xx.timestamp desc
limit 24 offset 0;

?