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 CAFvQSYTqNZmdBLx6JmcmjS8vk-mCWKYbNJfa91=-7hCpXJRJ-Q@mail.gmail.com
Whole thread Raw
In response to Re: Any disadvantages of using =ANY(ARRAY()) instead of IN?  (Clemens Eisserer <linuxhippy@gmail.com>)
Responses Re: Any disadvantages of using =ANY(ARRAY()) instead of IN?
List pgsql-performance
Hi again,

>> That doesn't sound like a tremendously good idea to me.
> Could you elaborate on the downsides of this approach a bit?

Any other thoughts about the pro/cons replacing IN(subquery) with
=ANY(ARRAY(subquery))?
Are there patological cases, except when the subquery returns a huge
amount of rows?

Should Ifile a bug-report about the optimizer trying too hard to
collapse the subquery and therefor generating a bad plan?

Thank you in advance, Clemens

pgsql-performance by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: scale up (postgresql vs mssql)
Next
From: Dan Fairs
Date:
Subject: Unexpected sequence scan