Postgres Pro
Downloads
Home   >   mailing lists

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.
List pgsql-performance
Tree view 
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.