Re: [PERFORM] Slow TSearch2 performance for table with 1 million documents.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Benjamin Arai <me(at)benjaminarai(dot)com>
Cc: Benjamin Arai <benjamin(at)araisoft(dot)com>, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, PostgreSQL <pgsql-general(at)postgresql(dot)org>, pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] Slow TSearch2 performance for table with 1 million documents.
Date: 2007-10-11 15:53:05
Message-ID: 21653.1192117985@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

Benjamin Arai <me(at)benjaminarai(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-10-11 16:03:47 Re: XMIN semantic at peril ?
Previous Message Richard Huxton 2007-10-11 15:50:57 Re: Support for distributed transactions in 8.2.5

Browse pgsql-performance by date

  From Date Subject
Next Message Benjamin Arai 2007-10-11 16:12:20 Re: [PERFORM] Slow TSearch2 performance for table with 1 million documents.
Previous Message Benjamin Arai 2007-10-11 14:52:29 Re: [PERFORM] Slow TSearch2 performance for table with 1 million documents.