Skip site navigation (1) Skip section navigation (2)

Re: Full text search with ORDER BY performance issue

From: Krade <krade(at)krade(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Full text search with ORDER BY performance issue
Date: 2009-07-21 00:25:02
Message-ID: 4A650ADE.3030905@krade.com (view raw or flat)
Thread:
Lists: 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.


In response to

pgsql-performance by date

Next:From: Alvaro HerreraDate: 2009-07-21 01:00:17
Subject: Re: Help needed for reading postgres log : RE: Concurrency issue under very heay loads
Previous:From: Tom LaneDate: 2009-07-20 23:34:38
Subject: Re: Calling conventions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group