Re: How to get around LIKE inefficiencies?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: The Hermit Hacker <scrappy(at)hub(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: How to get around LIKE inefficiencies?
Date: 2000-11-06 02:28:04
Message-ID: 1475.973477684@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

A brute-force answer would be to remove the url_url index ;-)
dunno if that would slow down other queries, however.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2000-11-06 02:36:32 Re: How to get around LIKE inefficiencies?
Previous Message Tatsuo Ishii 2000-11-06 01:05:52 Re: Unicode conversion (Re: [COMMITTERS] pgsql (configure.in))