Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
MIME-Version: 1.0
To: jdiehl@sandia.gov
Cc: pgsql-sql@postgresql.org, pgsql-performance@postgresql.org
From: "Nikolaus Dilger" <nikolaus@dilger.cc>
Subject: Re: Like search performance.
Date: Wed, 30 Apr 2003 10:08:28 -0700 (PDT)
Message-Id: <20030430100829.9198.h014.c001.wm@mail.dilger.cc.criticalpath.net>

Jeffrey,

The best thing you can do is to have the wildcard % as
late as possible in your search condition.
So do like 'd%' instead of like '%d%' if you can.

Regards,
Nikolaus


On Wed, 30 Apr 2003 10:34:40 -0600, "Diehl, Jeffrey"
wrote:

> 
> Hi all,
> 
> I have a fairly large table with a char(20) field in
it
> which I search on
> quite a bit.  The problem is that I tend to do a lot
of 
> "...where field like '%-d%'" type searches on this
> field.
> 
> Is there any to speed up this type of search?
> 
> TIA,
> 
> Mike Diehl.
> 
> 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster