Re: sequential scans on few columns tables

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Tomasz Myrta <jasiek(at)klaster(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: sequential scans on few columns tables
Date: 2003-06-16 19:55:51
Message-ID: 20030616195551.GB8871@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Jun 16, 2003 at 21:49:40 +0200,
Tomasz Myrta <jasiek(at)klaster(dot)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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tomasz Myrta 2003-06-16 20:32:32 Re: sequential scans on few columns tables
Previous Message Tomasz Myrta 2003-06-16 19:49:40 sequential scans on few columns tables