> 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 Lavender||Date: 2003-05-28 11:28:15|
|Previous:||From: Josh Berkus||Date: 2003-05-27 19:55:46|
|Subject: Re: Wildcard searches & performance question|