From: | Alexander Korotkov <akorotkov(at)postgresql(dot)org> |
---|---|
To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | pgsql: Fix selectivity estimation @> (anymultirange, anyrange) operator |
Date: | 2020-12-30 17:39:58 |
Message-ID: | E1kufS2-00033v-N1@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Fix selectivity estimation @> (anymultirange, anyrange) operator
Attempt to get selectivity estimation for @> (anymultirange, anyrange) operator
caused an error in buildfarm, because this operator was missed in switch()
of calc_hist_selectivity(). Fix that and also make regression tests reliably
check that selectivity estimation for (multi)ranges doesn't fall. Previously,
whether we test selectivity estimation for (multi)ranges depended on
whether autovacuum managed to gather concurrently to the test.
Reported-by: Michael Paquier
Discussion: https://postgr.es/m/X%2BwmgjRItuvHNBeV%40paquier.xyz
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/62097a4cc8c725fa86d3170396a8f30609acd0d3
Modified Files
--------------
src/backend/utils/adt/multirangetypes_selfuncs.c | 1 +
src/test/regress/expected/multirangetypes.out | 5 +++++
src/test/regress/expected/rangetypes.out | 5 +++++
src/test/regress/sql/multirangetypes.sql | 6 ++++++
src/test/regress/sql/rangetypes.sql | 6 ++++++
5 files changed, 23 insertions(+)
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander Korotkov | 2020-12-30 17:41:10 | Re: pgsql: Add support of multirange matching to the existing range GiST in |
Previous Message | Tom Lane | 2020-12-30 16:38:58 | pgsql: Fix up usage of krb_server_keyfile GUC parameter. |