From: | tgl(at)postgresql(dot)org (Tom Lane) |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Fix oversight in planning for multiple indexscans driven by |
Date: | 2006-07-01 22:07:24 |
Message-ID: | 20060701220724.087619FABE7@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Log Message:
-----------
Fix oversight in planning for multiple indexscans driven by
ScalarArrayOpExpr index quals: we were estimating the right total
number of rows returned, but treating the index-access part of the
cost as if a single scan were fetching that many consecutive index
tuples. Actually we should treat it as a multiple indexscan, and
if there are enough of 'em the Mackert-Lohman discount should kick in.
Modified Files:
--------------
pgsql/src/backend/optimizer/path:
costsize.c (r1.159 -> r1.160)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/costsize.c.diff?r1=1.159&r2=1.160)
pgsql/src/backend/utils/adt:
selfuncs.c (r1.207 -> r1.208)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/selfuncs.c.diff?r1=1.207&r2=1.208)
pgsql/src/include/utils:
selfuncs.h (r1.33 -> r1.34)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/selfuncs.h.diff?r1=1.33&r2=1.34)
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2006-07-02 01:58:36 | pgsql: ALTER TABLE ... |
Previous Message | Tom Lane | 2006-07-01 18:38:33 | pgsql: Revise the planner's handling of "pseudoconstant" WHERE clauses, |