Postgres Pro
Downloads
Home   >   mailing lists

Re: LIKE Query performance - Mailing list pgsql-performance

From Robert Haas
Subject Re: LIKE Query performance
Date
Msg-id 603c8f070901280608h8668aa3j37c11ef4a23b734e@mail.gmail.com
Whole thread Raw
In response to LIKE Query performance  ("Hari, Balaji" <Balaji_Hari@bmc.com>)
List pgsql-performance
Tree view 
> 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

pgsql-performance by date:

Previous
From: Phoenix Kiula
Date:
Subject: PG performance in high volume environment (many INSERTs and lots of aggregation reporting)
Next
From: Robert Haas
Date:
Subject: Re: PG performance in high volume environment (many INSERTs and lots of aggregation reporting)