Help with LIKE

Поиск
Список
Период
Сортировка
От David Olbersen
Тема Help with LIKE
Дата
Msg-id E7E213858379814A9AE48CA6754F5ECB0D6C2D@mail01.stbernard.com
обсуждение исходный текст
Ответы Re: [PERFORM] Help with LIKE  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-sql
I have a table with 8,628,633 rows that I'd LIKE to search (ha ha).

I have a very simple query:
  SELECT * FROM tableA WHERE column1 LIKE '%something%';

tableA.column1 has an index on it and the database has been vacuumed recently. My problem is with the output of
EXPLAIN:

+----------------------------------------------------------------+
|                         QUERY PLAN                             |
+----------------------------------------------------------------+
| Seq Scan on tableA  (cost=0.00..212651.61 rows=13802 width=46) |
|   Filter: (column1 ~~ '%something%'::text)                     |
+----------------------------------------------------------------+

I don't like that cost (2,12,651) at all! Is there anyway I can optimize this query? Make a different kind of index
(it'scurrently btree)? Use substr or indexof or something instead of LIKE? 

Thoughts?

--------------------------
David Olbersen
iGuard Engineer
11415 West Bernardo Court
San Diego, CA 92127
1-858-676-2277 x2152

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: SQL stored proc query (optimising)
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: [PERFORM] Help with LIKE