Re: How to boost performance of queries containing pattern matching characters

From: "Gnanakumar" <gnanam(at)zoniac(dot)com>
To: "'Richard Huxton'" <dev(at)archonet(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: How to boost performance of queries containing pattern matching characters
Date: 2011-02-14 08:02:14
Message-ID: 004c01cbcc1d$7fa04980$7ee0dc80$@com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> The closest you can do is something like Artur's option (or the pg_trgm
> module - handy since you are looking at 3-chars and up) to select likely
> matches combined with a separate search on '%domain.com%' to confirm
> that fact.

Thanks for your suggestion. Our production server is currently running
PostgreSQL v8.2.3. I think pg_trgm contrib module is not available for 8.2
series.

Also, I read about WildSpeed - fast wildcard search for LIKE operator. What
is your opinion on that?
http://www.sai.msu.su/~megera/wiki/wildspeed

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message david 2011-02-14 08:02:39 Re: choosing the right RAID level for PostgresQL database
Previous Message Richard Huxton 2011-02-14 07:56:56 Re: How to boost performance of queries containing pattern matching characters