Oh, I see. I didn't look carefully at the EXPLAIN ANALYZE I posted.
So, is there a solution to the rank problem?
Benjamin
On Oct 11, 2007, at 8:53 AM, Tom Lane wrote:
> Benjamin Arai <me@benjaminarai.com> writes:
>> It appears that the ORDER BY rank operation is the slowing factor.
>> If I remove it then the query is pretty fast. Is there another way
>> to perform ORDER BY such that it does not do a sort?
>
> I think you misunderstood: it's not the sort that's slow, it's the
> computation of the rank() values that are inputs to the sort.
>
> regards, tom lane
>