, January 28, 2009 1:27 AM
To: Hari, Balaji
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] LIKE Query performance
Only wildspeed http://www.sai.msu.su/~megera/wiki/wildspeed
has index support for %text%
But, it has limitations.
Oleg
On Tue, 27 Jan 2009, Hari, Balaji wrote:
Hi,
I am
mance@postgresql.org
Subject: Re: [PERFORM] LIKE Query performance
Only wildspeed http://www.sai.msu.su/~megera/wiki/wildspeed
has index support for %text%
But, it has limitations.
Oleg
On Tue, 27 Jan 2009, Hari, Balaji wrote:
> Hi,
>
> I am relatively new to PostgreSQL(8.1) and facing the fol
@postgresql.org
Subject: Re: [PERFORM] LIKE Query performance
Only wildspeed http://www.sai.msu.su/~megera/wiki/wildspeed
has index support for %text%
But, it has limitations.
Oleg
On Tue, 27 Jan 2009, Hari, Balaji wrote:
> Hi,
>
> I am relatively new to PostgreSQL(8.1) and facing the followin
> Is there any tweaks to force pgsql to use index on description?
Even if you could force it to use the index, it wouldn't make the
query run faster.
As others have pointed out, what you really need is a different kind of index...
...Robert
--
Sent via pgsql-performance mailing list (pgsql-per
In response to Hari, Balaji :
> Hi,
>
>
>
> I am relatively new to PostgreSQL(8.1) and facing the following problem.
Sure? 8.1? Your explain looks like 8.2 or 8.3. 8.3 contains a
full-text-search.
If really not 8.3 you can use tsearch2, it is a contrib-module.
Andreas
--
Andreas Kretschmer
On Wed, Jan 28, 2009 at 12:41 AM, Hari, Balaji wrote:
> EXPLAIN ANALYZE SELECT event_id, category, current_session_number,
> description, event_type_id, realm_name, root_session_number, severity,
> source_name, target_key, target_name, timestamp, jdo_version FROM event
> WHERE description like '%m
Only wildspeed http://www.sai.msu.su/~megera/wiki/wildspeed
has index support for %text%
But, it has limitations.
Oleg
On Tue, 27 Jan 2009, Hari, Balaji wrote:
Hi,
I am relatively new to PostgreSQL(8.1) and facing the following problem.
We have indexes defined on timestamp and description (
Hi,
I am relatively new to PostgreSQL(8.1) and facing the following problem.
We have indexes defined on timestamp and description (create index
description_idx on event using btree (description varchar_pattern_ops))
EXPLAIN ANALYZE SELECT event_id, category, current_session_number, description,
