pgsql: Fix oversight in planning for multiple indexscans driven by

Поиск
Список
Период
Сортировка
От tgl@postgresql.org (Tom Lane)
Тема pgsql: Fix oversight in planning for multiple indexscans driven by
Дата
Msg-id 20060701220724.087619FABE7@postgresql.org
обсуждение исходный текст
Список 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)

В списке pgsql-committers по дате отправления:

Предыдущее
От: tgl@postgresql.org (Tom Lane)
Дата:
Сообщение: pgsql: Revise the planner's handling of "pseudoconstant" WHERE clauses,
Следующее
От: momjian@postgresql.org (Bruce Momjian)
Дата:
Сообщение: pgsql: ALTER TABLE ...