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

From tgl@svr1.postgresql.org (Tom Lane)
Subject pgsql: Adjust estimate_num_groups() to not clamp per-relation group
Date
Msg-id 20050201230834.BD39F8B9B3A@svr1.postgresql.org
Whole thread Raw
List pgsql-committers
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 ...

Modified Files:
--------------
    pgsql/src/backend/utils/adt:
        selfuncs.c (r1.170 -> r1.171)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/selfuncs.c.diff?r1=1.170&r2=1.171)
    pgsql/src/test/regress/expected:
        subselect.out (r1.11 -> r1.12)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/subselect.out.diff?r1=1.11&r2=1.12)

pgsql-committers by date:

Previous
From: momjian@svr1.postgresql.org (Bruce Momjian)
Date:
Subject: pgsql: Add Josh's performance page.
Next
From: tgl@svr1.postgresql.org (Tom Lane)
Date:
Subject: pgsql: Adjust estimate_num_groups() to not clamp per-relation group