On Sun, Jul 19, 2009 at 12:07 AM, Krade<krade@xxxxxxxxx> 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;
?
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
