From 245021fa69be1d78a567e8c7348a41695d0a315a Mon Sep 17 00:00:00 2001 From: "yizhi.fzh" Date: Tue, 2 Apr 2024 14:47:54 +0800 Subject: [PATCH v1 6/8] Fast path for general clauselist_selectivity It should be common in the most queries like SELECT * FROM t1, t2 WHERE t1.a = t2.a AND t1.a > 3; clauses == NULL at the scan level of t2. --- src/backend/optimizer/path/clausesel.c | 3 +++ 1 file changed, 3 insertions(+) diff --git a/src/backend/optimizer/path/clausesel.c b/src/backend/optimizer/path/clausesel.c index 50210ec2ca..c4f5fae9d7 100644 --- a/src/backend/optimizer/path/clausesel.c +++ b/src/backend/optimizer/path/clausesel.c @@ -132,6 +132,9 @@ clauselist_selectivity_ext(PlannerInfo *root, int listidx; bool single_clause_optimization = true; + if (clauses == NULL) + return 1.0; + /* * The optimization of skipping to clause_selectivity_ext for single * clauses means we can't improve join estimates with a single join -- 2.34.1