Postgres Pro
Downloads
Home   >   mailing lists

Re: Any disadvantages of using =ANY(ARRAY()) instead of IN? - Mailing list pgsql-performance

From Clemens Eisserer
Subject Re: Any disadvantages of using =ANY(ARRAY()) instead of IN?
Date
Msg-id CAFvQSYTuWsJ7k4d6otj6nWpvRAEw27_7aa6SNyofT3Yz+p00Yg@mail.gmail.com
Whole thread Raw
In response to Re: Any disadvantages of using =ANY(ARRAY()) instead of IN?  (Clemens Eisserer <linuxhippy@gmail.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: "MauMau"
Date:
Subject: Could synchronous streaming replication really degrade the performance of the primary?
Next
From: Merlin Moncure
Date:
Subject: Re: Could synchronous streaming replication really degrade the performance of the primary?