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

Re: LIKE Query performance

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: "Hari, Balaji" <Balaji_Hari(at)bmc(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: LIKE Query performance
Date: 2009-01-28 14:08:50
Message-ID: 603c8f070901280608h8668aa3j37c11ef4a23b734e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
> Is there any tweaks to force pgsql to use index on description?

Even if you could force it to use the index, it wouldn't make the
query run faster.

As others have pointed out, what you really need is a different kind of index...

...Robert

In response to

pgsql-performance by date

Next:From: Robert HaasDate: 2009-01-28 14:18:52
Subject: Re: PG performance in high volume environment (many INSERTs and lots of aggregation reporting)
Previous:From: Phoenix KiulaDate: 2009-01-28 13:33:50
Subject: PG performance in high volume environment (many INSERTs and lots of aggregation reporting)

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