Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-performancepgsql-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

pgsql-performance by date

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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group