On Wed, Jan 28, 2009 at 12:41 AM, Hari, Balaji <Balaji_Hari@bmc.com> 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.