Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] Slow TSearch2 performance for table with 1 million documents. - Mailing list pgsql-general

From Tom Lane
Subject Re: [PERFORM] Slow TSearch2 performance for table with 1 million documents.
Date
Msg-id 21653.1192117985@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PERFORM] Slow TSearch2 performance for table with 1 million documents.  (Benjamin Arai <me@benjaminarai.com>)
Responses Re: [PERFORM] Slow TSearch2 performance for table with 1 million documents.
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Support for distributed transactions in 8.2.5
Next
From: Nis Jørgensen
Date:
Subject: Re: Calculation of per Capita on-the-fly - problems with SQL syntax