From: David Leangen <postgres@leangen.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: Improving query performance
Date: Fri, 02 Mar 2007 18:06:06 +0900
Message-ID: <1172826366.27446.16.camel@sonoda.bioscene.co.jp> (raw)
In-Reply-To: <1763.1172814488@sss.pgh.pa.us>
References: <1172808030.27446.12.camel@sonoda.bioscene.co.jp>
<1763.1172814488@sss.pgh.pa.us>
> > And this is the actual query:
>
> I think you need to look into full-text indexing (see tsearch2).
Thanks, Tom.
Yes, we know this.
This is just a temporary fix that we needed to get up today for biz
reasons. Implementing full-text searching within a few short hours was
out of the question.
Anyway, we found a temporary solution. We'll be doing this "properly"
later.
Thanks for taking the time to suggest this.
Cheers,
Dave
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: postgres@leangen.net, tgl@sss.pgh.pa.us
Subject: Re: Improving query performance
In-Reply-To: <1172826366.27446.16.camel@sonoda.bioscene.co.jp>
* 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