| From: | David Rowley <drowley(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: Support partition pruning on boolcol IS [NOT] UNKNOWN |
| Date: | 2024-03-04 01:45:10 |
| Message-ID: | E1rgxOA-001xRk-2R@gemulon.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Support partition pruning on boolcol IS [NOT] UNKNOWN
While working on 4c2369ac5, I noticed we went out of our way not to
support clauses on boolean partitioned tables in the form of "IS
UNKNOWN" and "IS NOT UNKNOWN". It's almost as much code to disallow
this as it is to allow it, so let's allow it.
Discussion: https://postgr.es/m/CAApHDvobKtcN6+xOuOfcutfp6T7jP=JPA9y3=MAEqnuKdDsQrw@mail.gmail.com
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/07c36c1333e00df5a4baf6b04ba2f3f300f57d69
Modified Files
--------------
src/backend/partitioning/partprune.c | 71 +++++++++++++++------------
src/test/regress/expected/partition_prune.out | 56 +++++++++++++++++----
src/test/regress/sql/partition_prune.sql | 7 +++
3 files changed, 93 insertions(+), 41 deletions(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2024-03-04 04:42:31 | pgsql: Optimize GenerationAlloc() and SlabAlloc() |
| Previous Message | Michael Paquier | 2024-03-04 01:37:58 | pgsql: Add PostgreSQL::Test::Cluster::wait_for_event() |