How to boost performance of ilike queries ?

From: Antony Paul <antonypaul24(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: How to boost performance of ilike queries ?
Date: 2005-01-24 09:18:10
Message-ID: 2989532e05012401184b0c3ef9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,
I have a query which is executed using ilike. The query values are
received from user and it is executed using PreparedStatement.
Currently all queries are executed as it is using iilike irrespective
of whether it have a pattern matching character or not. Can using =
instead of ilike boot performance ?. If creating index can help then
how the index should be created on lower case or uppercase ?.

rgds
Antony Paul

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andrei Reinus 2005-01-24 09:22:13 Re: poor performance of db?
Previous Message Simon Riggs 2005-01-24 08:41:37 Faster and more frequent VACUUM (was PostgreSQL clustering VS MySQL clustering)