On Wed, Jan 28, 2009 at 12:41 AM, Hari, Balaji <Balaji_Hari@xxxxxxx> 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. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
