Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
    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 ?.

Antony Paul


pgsql-performance by date

Next:From: Andrei ReinusDate: 2005-01-24 09:22:13
Subject: Re: poor performance of db?
Previous:From: Simon RiggsDate: 2005-01-24 08:41:37
Subject: Faster and more frequent VACUUM (was PostgreSQL clustering VSMySQL clustering)

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group