Like search performance.

From: "Diehl, Jeffrey" <jdiehl(at)sandia(dot)gov>
To: pgsql-sql(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: Like search performance.
Date: 2003-04-30 16:34:40
Message-ID: B51F0C636E578A4E832D3958690CD73E0130C417@es04snlnt.sandia.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance pgsql-sql

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.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message SZUCS Gábor 2003-04-30 16:59:52 Re: Like search performance.
Previous Message Jean-Luc Lachance 2003-04-30 16:23:11 Re: Why LIMIT after scanning the table?

Browse pgsql-sql by date

  From Date Subject
Next Message Martin Chantler 2003-04-30 16:52:00 Stored Procedure Question
Previous Message Josh Berkus 2003-04-30 16:03:38 Re: [SQL] 7.3 analyze & vacuum analyze problem