Re: Wildcard searches & performance question

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Grega Bremec <grega(dot)bremec(at)noviforum(dot)si>
Cc: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Wildcard searches & performance question
Date: 2003-05-27 20:06:26
Message-ID: 1054065986.93507.43.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> feasible in such cases? Or in other words, can I somehow optimize LIKE and
> regexp queries that start with a wildcard?

If they start with a wildcard, but end in character data you could
reverse the string and index that...

If they start and end with a wildcard, your best bet is a full text
indexing solution (various contrib modules).

--
Rod Taylor <rbt(at)rbt(dot)ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Peter Lavender 2003-05-28 11:28:15
Previous Message Josh Berkus 2003-05-27 19:55:46 Re: Wildcard searches & performance question