git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit

Improve estimation of ANDs under ORs using extended statistics.

author Dean Rasheed <dean.a.rasheed@gmail.com>

Tue, 8 Dec 2020 20:10:11 +0000 (20:10 +0000)

committer Dean Rasheed <dean.a.rasheed@gmail.com>

Tue, 8 Dec 2020 20:10:11 +0000 (20:10 +0000)

commit 4f5760d4afa9423fe4d38e4cbec48bf5e793e7e5

tree e2f545d18e44849f81d593c181c08c9bcb77126d tree

parent 88b0898fe35a5a0325fca21bd4f3ed6dffb364c1 commit | diff

Improve estimation of ANDs under ORs using extended statistics.

Formerly, extended statistics only handled clauses that were
RestrictInfos. However, the restrictinfo machinery doesn't create
sub-AND RestrictInfos for AND clauses underneath OR clauses.
Therefore teach extended statistics to handle bare AND clauses,
looking for compatible RestrictInfo clauses underneath them.

Dean Rasheed, reviewed by Tomas Vondra.

Discussion: https://postgr.es/m/CAEZATCW=J65GUFm50RcPv-iASnS2mTXQbr=CfBvWRVhFLJ_fWA@mail.gmail.com

src/backend/optimizer/path/clausesel.c diff | blob | blame | history

src/backend/statistics/extended_stats.c diff | blob | blame | history

src/test/regress/expected/stats_ext.out diff | blob | blame | history

This is the main PostgreSQL git repository.

RSS Atom