Re: [PERFORM] LIKE Query performance

2009-01-29 Thread Hari, Balaji
We won't need full text searching capabilities as in documents as the data type is varchar. Wildspeed will exactly fit our needs. -Original Message- From: Oleg Bartunov [mailto:o...@sai.msu.su] Sent: Wednesday, January 28, 2009 1:27 AM To: Hari, Balaji Cc: pgsql-perfor

Re: [PERFORM] LIKE Query performance

2009-01-29 Thread Hari, Balaji
Is there a patch to make Wildspeed work with postgresql version 8.3.1? P.S My bad, the version number was incorrect in my previous mail. -Original Message- From: Oleg Bartunov [mailto:o...@sai.msu.su] Sent: Wednesday, January 28, 2009 1:27 AM To: Hari, Balaji Cc: pgsql-performance

[PERFORM] LIKE Query performance

2009-01-27 Thread Hari, Balaji
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,