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
Subject: Re: Any disadvantages of using =ANY(ARRAY()) instead of IN?
Date: 2012-05-04 13:19:06
Message-ID: CAFvQSYTqNZmdBLx6JmcmjS8vk-mCWKYbNJfa91=-7hCpXJRJ-Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Dan Fairs 2012-05-04 14:24:33 Unexpected sequence scan
Previous Message Merlin Moncure 2012-05-04 13:04:09 Re: scale up (postgresql vs mssql)