Re: LIKE Query performance

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 '%mismatch%' ORDER BY timestamp desc;
(...)
> Is there any tweaks to force pgsql to use index on description?

How long is usually the description? For me it sounds like the job for
tsearch2 module, which should be in "contrib" section in 8.1.