Re: Improving query performance

Поиск
Список
Период
Сортировка
От David Leangen
Тема Re: Improving query performance
Дата
Msg-id 1172826366.27446.16.camel@sonoda.bioscene.co.jp
обсуждение исходный текст
Ответ на Re: Improving query performance  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
> > And this is the actual query:
>
> I think you need to look into full-text indexing (see tsearch2).


Thanks, Tom.

Yes, we know this.

This is just a temporary fix that we needed to get up today for biz
reasons. Implementing full-text searching within a few short hours was
out of the question.


Anyway, we found a temporary solution. We'll be doing this "properly"
later.


Thanks for taking the time to suggest this.


Cheers,
Dave




В списке pgsql-performance по дате отправления:

Предыдущее
От: Florian Weimer
Дата:
Сообщение: Re: strange performance regression between 7.4 and 8.1
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: stats collector process high CPU utilization