Re: Any disadvantages of using =ANY(ARRAY()) instead of IN?
- To: pgsql-performance@xxxxxxxxxxxxxx, tgl@xxxxxxxxxxxxx
- Subject: Re: Any disadvantages of using =ANY(ARRAY()) instead of IN?
- From: Clemens Eisserer <linuxhippy@xxxxxxxxx>
- Date: Wed, 9 May 2012 15:27:39 +0200
- In-reply-to: <CAFvQSYTqNZmdBLx6JmcmjS8vk-mCWKYbNJfa91=-7hCpXJRJ-Q@mail.gmail.com>
- References: <CAFvQSYTNtqmd5F9ZWbmxGwm2A4UGoanSuD3p=0f+yzFwpKcq6g@mail.gmail.com> <13236.1335883438@sss.pgh.pa.us> <CAFvQSYSAcrEcJS9YYuvZtiN_8DjOt3G5YOu=YZ8ksDiFdLzZuA@mail.gmail.com> <CAFvQSYTqNZmdBLx6JmcmjS8vk-mCWKYbNJfa91=-7hCpXJRJ-Q@mail.gmail.com>
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
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
[Postgresql General]
[Postgresql PHP]
[PHP Users]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Home]
[Yosemite]