Patch: improve selectivity estimation for IN/NOT IN

Daniele Varrazzo <daniele.varrazzo@gmail.com>

From: Daniele Varrazzo <daniele.varrazzo@gmail.com>

To: PostgreSQL Hackers <pgsql-hackers@postgresql.org>

Date: 2012-03-03T19:52:32Z

Lists: pgsql-hackers

Attachments

0001-Improve-array-selectivity-estimation-for-ANY-and-ALL.patch (text/x-patch) patch 0001

Hello,

the attached patch improves the array selectivity estimation for = ANY
and <> ALL, hence for the IN/NOT IN operators, to avoid the
shortcoming described in
<http://archives.postgresql.org/pgsql-performance/2012-03/msg00006.php>.

Cheers,

-- Daniele