Postgres Pro
Downloads
Home   >   mailing lists

Re: LIKE foo% optimization easily defeated by OR? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: LIKE foo% optimization easily defeated by OR?
Date
Msg-id 31434.1515020643@sss.pgh.pa.us
Whole thread Raw
In response to Re: LIKE foo% optimization easily defeated by OR?  (Greg Stark <stark@mit.edu>)
Responses Re: LIKE foo% optimization easily defeated by OR?
List pgsql-hackers
Tree view 
Greg Stark <stark@mit.edu> writes:
> On 3 January 2018 at 22:34, Alexander Korotkov
> <a.korotkov@postgrespro.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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: TupleDescCopy doesn't clear atthasdef, attnotnull, attidentity
Next
From: Greg Stark
Date:
Subject: Re: LIKE foo% optimization easily defeated by OR?