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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [PERFORM] Slow TSearch2 performance for table with 1 million documents.
Дата
Msg-id 21653.1192117985@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [PERFORM] Slow TSearch2 performance for table with 1 million documents.  (Benjamin Arai <me@benjaminarai.com>)
Ответы Re: [PERFORM] Slow TSearch2 performance for table with 1 million documents.  (Benjamin Arai <me@benjaminarai.com>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Support for distributed transactions in 8.2.5
Следующее
От: Nis Jørgensen
Дата:
Сообщение: Re: Calculation of per Capita on-the-fly - problems with SQL syntax