Re: Improving query performance - Mailing list pgsql-performance

From David Leangen
Subject Re: Improving query performance
Date
Msg-id 1172826366.27446.16.camel@sonoda.bioscene.co.jp
Whole thread Raw
In response to Re: Improving query performance  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
> > 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




pgsql-performance by date:

Previous
From: Florian Weimer
Date:
Subject: Re: strange performance regression between 7.4 and 8.1
Next
From: Magnus Hagander
Date:
Subject: Re: stats collector process high CPU utilization