От: Tom Lane
Тема: Re: Query tuning help
Дата: ,
Msg-id: 15030.1115600302@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: Re: Query tuning help  (Russell Smith)
Список: pgsql-performance

Скрыть дерево обсуждения

Query tuning help  (Dan Harris, )
 Re: Query tuning help  (Josh Berkus, )
 Re: Query tuning help  (Russell Smith, )
  Re: Query tuning help  (Tom Lane, )
  Re: Query tuning help  (Dan Harris, )
   Re: Query tuning help  (Josh Berkus, )
    Re: Query tuning help  (Dan Harris, )
     Re: Query tuning help  (Klint Gore, )
   Re: Query tuning help  (Tom Lane, )
   Re: Query tuning help  (Russell Smith, )
    Re: Query tuning help  (Dan Harris, )
    Re: Query tuning help  (Mischa Sandberg, )
 Re: Query tuning help  (Harald Fuchs, )
 Re: Query tuning help  (Ulrich Wisser, )

Russell Smith <> writes:
> On Mon, 9 May 2005 09:20 am, Dan Harris wrote:
>> and (  recordtext like '%RED%' or recordtext like '%CORVETTE%'  )
>>
> You cannot use an index for %CORVETTE%, or %RED%.

Not a btree index anyway.  Dan might have some success here with a
full-text-indexing package (eg, contrib/tsearch2)

            regards, tom lane


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

От: Grega Bremec
Дата:
Сообщение: Re: sequence scan on PK
От: Harald Fuchs
Дата:
Сообщение: Re: Query tuning help