Re: LIKE foo% optimization easily defeated by OR?

From: Greg Stark <stark(at)mit(dot)edu>
To: Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: LIKE foo% optimization easily defeated by OR?
Date: 2018-01-03 22:55:41
Message-ID: CAM-w4HMCCnZvrwcV+11UOEgynG4OKFJV=PcUxe5Vf4s690xxqw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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. I
have checked with enable_seqscan=off but I'll have to do some more
investigations. I'll try it on different instances of the database.

--
greg

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Korotkov 2018-01-03 23:00:17 Re: [HACKERS] Pluggable storage
Previous Message Alexander Korotkov 2018-01-03 22:34:44 Re: LIKE foo% optimization easily defeated by OR?