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.
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.marlowe||Date: 2003-05-27 19:48:39|
|Subject: Re: Wildcard searches & performance question|
|Previous:||From: Grega Bremec||Date: 2003-05-27 19:09:08|
|Subject: Wildcard searches & performance question|