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

Re: Wildcard searches & performance question

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Wildcard searches & performance question
Date: 2003-05-27 19:37:00
Message-ID: 20030527193700.GB4459@libertyrms.info (view raw or flat)
Thread:
Lists: pgsql-performance
On Tue, May 27, 2003 at 09:09:08PM +0200, Grega Bremec wrote:
> that start with a wildcard, and would avoiding sequential scans even be
> feasible in such cases? Or in other words, can I somehow optimize LIKE and
> regexp queries that start with a wildcard?

Not really.  But it sounds like you might be a candidate for full
text indexing.  See contrib/tsearch for one implementation.

A

-- 
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info>                              M2P 2A8
                                         +1 416 646 3304 x110


In response to

pgsql-performance by date

Next:From: scott.marloweDate: 2003-05-27 19:48:39
Subject: Re: Wildcard searches & performance question
Previous:From: Grega BremecDate: 2003-05-27 19:09:08
Subject: Wildcard searches & performance question

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