Like search performance. - Mailing list pgsql-performance

From Diehl, Jeffrey
Subject Like search performance.
Date
Msg-id B51F0C636E578A4E832D3958690CD73E0130C417@es04snlnt.sandia.gov
Whole thread Raw
Responses Re: Like search performance.  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
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.


pgsql-performance by date:

Previous
From: Jean-Luc Lachance
Date:
Subject: Re: Why LIMIT after scanning the table?
Next
From: "Nikolaus Dilger"
Date:
Subject: Re: Like search performance.