Re: sequential scans on few columns tables - Mailing list pgsql-performance

From Tomasz Myrta
Subject Re: sequential scans on few columns tables
Date
Msg-id 3EEE2960.9080707@klaster.net
Whole thread Raw
In response to Re: sequential scans on few columns tables  (Bruno Wolff III <bruno@wolff.to>)
List 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 by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: sequential scans on few columns tables
Next
From: Dawn Hollingsworth
Date:
Subject: Postgres Connections Requiring Large Amounts of Memory