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

Hello,

On 7/20/2009 22:42, Kevin Grittner wrote:
> Have you considered keeping rows "narrow" until you've identified your
> 24 rows?  Something like:
>
> SELECT * FROM a
>    WHERE id in
>      (
>        SELECT id FROM a
>          WHERE comment_tsv @@ plainto_tsquery('love')
>          ORDER BY timestamp DESC
>          LIMIT 24 OFFSET 0
>      )
>    ORDER BY timestamp DESC
> ;
>
Good idea, but it doesn't really seem to do much. The query times are
roughly the same.