Re: Improving query performance

От: Tom Lane
Тема: Re: Improving query performance
Дата: ,
Msg-id: 1763.1172814488@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: Improving query performance  (David Leangen)
Ответы: Re: Improving query performance  (David Leangen)
Список: pgsql-performance

David Leangen <> writes:
> And this is the actual query:

> SELECT COUNT(t0.ID) FROM public.MY_TABLE t0
> WHERE ((POSITION('adenosine cyclic 35-monophosphate' IN LOWER(t0.TITLE))
> - 1) >=0 OR
> (POSITION('adenosine cyclic 55-monophosphate' IN LOWER(t0.TEXT)) - 1) >=
> 0 OR
> (POSITION('cyclic amp, disodium salt' IN LOWER(t0.TITLE)) - 1) >= 0 OR
> (POSITION('cyclic amp, disodium salt' IN LOWER(t0.TEXT)) - 1) >= 0 OR
> (POSITION('cyclic amp, sodium salt' IN LOWER(t0.TEXT)) - 1) >= 0 OR
> ...etc...

I think you need to look into full-text indexing (see tsearch2).

            regards, tom lane


В списке pgsql-performance по дате сообщения:

От: Magnus Hagander
Дата:
Сообщение: Re: stats collector process high CPU utilization
От: Carlos Moreno
Дата:
Сообщение: Re: strange performance regression between 7.4 and 8.1