| From: | tgl(at)svr1(dot)postgresql(dot)org (Tom Lane) |
|---|---|
| To: | pgsql-committers(at)postgresql(dot)org |
| Subject: | pgsql: Adjust estimate_num_groups() to not clamp per-relation group |
| Date: | 2005-02-01 23:08:34 |
| Message-ID: | 20050201230834.BD39F8B9B3A@svr1.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-02-01 23:09:06 | pgsql: Adjust estimate_num_groups() to not clamp per-relation group |
| Previous Message | Bruce Momjian | 2005-02-01 21:11:06 | pgsql: Add Josh's performance page. |