]> git.ipfire.org Git - thirdparty/postgresql.git/commit
projects / thirdparty / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: f2a69b3) | patch
Improve estimation of OR clauses using multiple extended statistics.
authorDean Rasheed <dean.a.rasheed@gmail.com>
Tue, 8 Dec 2020 19:39:24 +0000 (19:39 +0000)
committerDean Rasheed <dean.a.rasheed@gmail.com>
Tue, 8 Dec 2020 19:39:24 +0000 (19:39 +0000)
commit88b0898fe35a5a0325fca21bd4f3ed6dffb364c1
treefd18e47ff06c40a6349c27f30b29ad57deedde82tree | snapshot
parentf2a69b352de1dffc534c4835010e736018aa94decommit | diff
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
src/backend/statistics/extended_stats.c diff | blob | blame | history
src/test/regress/expected/stats_ext.out diff | blob | blame | history
Mirror of https://git.postgresql.org/git/postgresql.git