Thread: pgsql: Adjust estimate_num_groups() to not clamp per-relation group

pgsql: Adjust estimate_num_groups() to not clamp per-relation group

From

tgl@svr1.postgresql.org (Tom Lane)

Date:

02 February 2005, 02:09:11

Log Message:
-----------
Adjust estimate_num_groups() to not clamp per-relation group count
estimate to less than the number of values estimated for any one grouping
Var, as suggested by Manfred.  This is intuitively right, and what's
more it puts the plan choices in the subselect regression test back the
way they were before ...

Tags:
----
REL8_0_STABLE

Modified Files:
--------------
    pgsql/src/backend/utils/adt:
        selfuncs.c (r1.169.4.1 -> r1.169.4.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/selfuncs.c.diff?r1=1.169.4.1&r2=1.169.4.2)
    pgsql/src/test/regress/expected:
        subselect.out (r1.10.4.1 -> r1.10.4.2)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/subselect.out.diff?r1=1.10.4.1&r2=1.10.4.2)