| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2003-04-30 18:48:18 | Re: [SQL] 7.3 analyze & vacuum analyze problem |
| Previous Message | Nikolaus Dilger | 2003-04-30 17:08:28 | Re: Like search performance. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2003-04-30 18:03:02 | Re: Stored Procedure Question |
| Previous Message | Nikolaus Dilger | 2003-04-30 17:08:28 | Re: Like search performance. |