Re: sequential scans on few columns tables

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: sequential scans on few columns tables
Дата
Msg-id 20030616195551.GB8871@wolff.to
обсуждение исходный текст
Ответ на sequential scans on few columns tables  (Tomasz Myrta <jasiek@klaster.net>)
Ответы Re: sequential scans on few columns tables
Список pgsql-performance
On Mon, Jun 16, 2003 at 21:49:40 +0200,
  Tomasz Myrta <jasiek@klaster.net> wrote:
> Hi
> Recently I was wondering about tables difficult to index. Example -
> queries with "ilike" where clauses. Without additional contrib modules
> the only way to search such tables is sequential scan (am I right?)

You might be able to use a functional index depending on exactly what your
search patterns are like.

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

Предыдущее
От: Tomasz Myrta
Дата:
Сообщение: sequential scans on few columns tables
Следующее
От: Tomasz Myrta
Дата:
Сообщение: Re: sequential scans on few columns tables