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

Re: Like search performance.

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Diehl, Jeffrey" <jdiehl(at)sandia(dot)gov>, pgsql-sql(at)postgresql(dot)org,pgsql-performance(at)postgresql(dot)org
Subject: Re: Like search performance.
Date: 2003-04-30 17:33:17
Message-ID: 200304301033.18357.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-performancepgsql-sql
Mike,

> 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?

Yes.  See the tsearch module in /contrib in your postgresql source.

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco


In response to

pgsql-performance by date

Next:From: Josh BerkusDate: 2003-04-30 18:48:18
Subject: Re: [SQL] 7.3 analyze & vacuum analyze problem
Previous:From: Nikolaus DilgerDate: 2003-04-30 17:08:28
Subject: Re: Like search performance.

pgsql-sql by date

Next:From: Stephan SzaboDate: 2003-04-30 18:03:02
Subject: Re: Stored Procedure Question
Previous:From: Nikolaus DilgerDate: 2003-04-30 17:08:28
Subject: Re: Like search performance.

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