Обсуждение: pgsql: Adjust nodeBitmapIndexscan to keep the target index opened from

Поиск
Список
Период
Сортировка

pgsql: Adjust nodeBitmapIndexscan to keep the target index opened from

От
tgl@svr1.postgresql.org (Tom Lane)
Дата:
Log Message:
-----------
Adjust nodeBitmapIndexscan to keep the target index opened from plan
startup to end, rather than re-opening it in each MultiExecBitmapIndexScan
call.  I had foolishly thought that opening/closing wouldn't be much
more expensive than a rescan call, but that was sheer brain fade.

This seems to fix about half of the performance lossage reported by
Sergey Koposov.  I'm still not sure where the other half went.

Modified Files:
--------------
    pgsql/src/backend/executor:
        nodeBitmapIndexscan.c (r1.7 -> r1.8)

(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeBitmapIndexscan.c.diff?r1=1.7&r2=1.8)
    pgsql/src/include/nodes:
        execnodes.h (r1.130 -> r1.131)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/execnodes.h.diff?r1=1.130&r2=1.131)