| From: | Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: Improve estimation of OR clauses using multiple extended statist |
| Date: | 2020-12-08 19:43:05 |
| Message-ID: | E1kmit7-0001uI-Tv@gemulon.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Improve estimation of OR clauses using multiple extended statistics.
When estimating an OR clause using multiple extended statistics
objects, treat the estimates for each set of clauses for each
statistics object as independent of one another. The overlap estimates
produced for each statistics object do not apply to clauses covered by
other statistics objects.
Dean Rasheed, reviewed by Tomas Vondra.
Discussion: https://postgr.es/m/CAEZATCW=J65GUFm50RcPv-iASnS2mTXQbr=CfBvWRVhFLJ_fWA@mail.gmail.com
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/88b0898fe35a5a0325fca21bd4f3ed6dffb364c1
Modified Files
--------------
src/backend/statistics/extended_stats.c | 25 +++++++++++++++++--------
src/test/regress/expected/stats_ext.out | 2 +-
2 files changed, 18 insertions(+), 9 deletions(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dean Rasheed | 2020-12-08 20:12:02 | pgsql: Improve estimation of ANDs under ORs using extended statistics. |
| Previous Message | Tom Lane | 2020-12-08 18:10:16 | pgsql: Doc: clarify that CREATE TABLE discards redundant unique constra |