Re: sequential scans on few columns tables

Поиск
Список
Период
Сортировка
От Tomasz Myrta
Тема Re: sequential scans on few columns tables
Дата
Msg-id 3EEE2960.9080707@klaster.net
обсуждение исходный текст
Ответ на Re: sequential scans on few columns tables  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-performance
Dnia 2003-06-16 21:55, Użytkownik Bruno Wolff III napisał:
> 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.
Probably functional indexes won't be helpful to find _substrings_.
Tomasz


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

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: sequential scans on few columns tables
Следующее
От: Dawn Hollingsworth
Дата:
Сообщение: Postgres Connections Requiring Large Amounts of Memory