pgsql: Fix selectivity estimation @> (anymultirange, anyrange) operator

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(+)

Browse pgsql-committers by date

  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.