From: Greg Smith <greg@2ndquadrant.com>
To: gnanam@zoniac.com
Cc: Richard Huxton <dev@archonet.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: How to boost performance of queries containing pattern matching characters
Date: Mon, 14 Feb 2011 10:16:27 -0500
Message-ID: <4D59474B.8060305@2ndquadrant.com> (raw)
In-Reply-To: <004c01cbcc1d$7fa04980$7ee0dc80$@com>
References: <004601cbcc14$acfe99d0$06fbcd70$@com>
<4D58D752.2000100@archonet.com>
<004701cbcc18$c54c8980$4fe59c80$@com>
<4D58DC35.8010007@archonet.com>
<004801cbcc1b$3f1d4fe0$bd57efa0$@com>
<4D58E048.9020506@archonet.com>
<004c01cbcc1d$7fa04980$7ee0dc80$@com>
Gnanakumar wrote:
> 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.
>
You're going to find that most of the useful answers here will not work
on 8.2. Full-text search was not fully integrated into the database
until 8.3. Trying to run an app using it on 8.2 is going to be a
constant headache for you. Also, moving from 8.2 to 8.3 is just a
general performance boost in many ways.
> 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
>
WildSpeed works fine if you can handle the massive disk space and
maintenance overhead it introduces. I consider it useful only for data
sets that are almost static, where you can afford to build its large
index structure once and then use it to accelerate reads continuously,
with minimal updates.
--
Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: greg@2ndquadrant.com, gnanam@zoniac.com, dev@archonet.com
Subject: Re: How to boost performance of queries containing pattern matching characters
In-Reply-To: <4D59474B.8060305@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox