Re: Any disadvantages of using =ANY(ARRAY()) instead of IN?

From: Clemens Eisserer <linuxhippy(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org, tgl(at)sss(dot)pgh(dot)pa(dot)us
Subject: Re: Any disadvantages of using =ANY(ARRAY()) instead of IN?
Date: 2012-05-09 13:27:39
Message-ID: CAFvQSYTuWsJ7k4d6otj6nWpvRAEw27_7aa6SNyofT3Yz+p00Yg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

I would be really grateful for feedback regardding this issue. Tom?

Should Ifile a bug-report about the optimizer trying too hard to
collapse the subquery and therefor generating a bad plan?
Its my understanding that a IN shouldn't perform any worse than ANY on
an ARRAY, right?

Thank you in advance, Clemens

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2012-05-09 13:58:04 Re: Could synchronous streaming replication really degrade the performance of the primary?
Previous Message MauMau 2012-05-09 13:06:17 Could synchronous streaming replication really degrade the performance of the primary?