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

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Peter LavenderDate: 2003-05-28 11:28:15
Subject:
Previous:From: Josh BerkusDate: 2003-05-27 19:55:46
Subject: Re: Wildcard searches & performance question

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