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

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

Previous
From: Tomasz Myrta
Date:
Subject: sequential scans on few columns tables
Next
From: Tomasz Myrta
Date:
Subject: Re: sequential scans on few columns tables