Support boolcol IS [NOT] UNKNOWN in partition pruning

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Support boolcol IS [NOT] UNKNOWN in partition pruning
Date: 2024-02-20 02:38:44
Message-ID: CAApHDvobKtcN6+xOuOfcutfp6T7jP=JPA9y3=MAEqnuKdDsQrw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

While working on 4c2369ac5, I noticed there's close to as much code to
disallow BooleanTests in the form of "IS UNKNOWN" and "IS NOT UNKNOWN"
in partition pruning as it would take to allow pruning to work for
these.

The attached makes it work.

David

Attachment Content-Type Size
v1-0001-Support-partition-pruning-on-boolcol-IS-NOT-UNKNO.patch text/plain 10.0 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrei Lepikhov 2024-02-20 02:49:38 Re: Memory consumed by paths during partitionwise join planning
Previous Message wenhui qiu 2024-02-20 02:16:00 Re: Thoughts about NUM_BUFFER_PARTITIONS