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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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