Adjust nodeBitmapIndexscan to keep the target index opened from plan
Tom Lane <tgl@sss.pgh.pa.us>
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.
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/executor/nodeBitmapIndexscan.c | modified | +43 −29 |
| src/include/nodes/execnodes.h | modified | +5 −1 |