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.