Re: LIKE foo% optimization easily defeated by OR?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Stark <stark(at)mit(dot)edu>
Cc: Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: LIKE foo% optimization easily defeated by OR?
Date: 2018-01-03 23:04:03
Message-ID: 31434.1515020643@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Greg Stark <stark(at)mit(dot)edu> writes:
> On 3 January 2018 at 22:34, Alexander Korotkov
> <a(dot)korotkov(at)postgrespro(dot)ru> wrote:
>> I've checked similar case on database with PostgreSQL mailing lists. It
>> works for me.

> Wow that's fascinating. I wonder why it's not kicking in for me.

text vs varchar maybe?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2018-01-03 23:06:17 Re: LIKE foo% optimization easily defeated by OR?
Previous Message Tom Lane 2018-01-03 23:01:28 Re: TupleDescCopy doesn't clear atthasdef, attnotnull, attidentity