aboutsummaryrefslogtreecommitdiff
path: root/src/backend/executor/functions.c
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2011-11-02 17:53:49 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2011-11-02 17:53:49 -0400
commit882368e854b6f094f94aca292f390bbd9f44359b (patch)
tree3516959d9078a761a223aa540c0ef153d3461f92 /src/backend/executor/functions.c
parent750f70b0fe91258f9f99b1d04a510e5b035e9249 (diff)
downloadpostgresql-882368e854b6f094f94aca292f390bbd9f44359b.tar.gz
postgresql-882368e854b6f094f94aca292f390bbd9f44359b.zip
Fix btree stop-at-nulls logic properly.
As pointed out by Naoya Anzai, my previous try at this was a few bricks shy of a load, because I had forgotten that the initial-positioning logic might not try to skip over nulls at the end of the index the scan will start from. We ought to fix that, because it represents an unnecessary inefficiency, but first let's get the scan-stop logic back to a safe state. With this patch, we preserve the performance benefit requested in bug #6278 for the case of scanning forward into NULLs (in a NULLS LAST index), but the reverse case of scanning backward across NULLs when there's no suitable initial-positioning qual is still inefficient.
Diffstat (limited to 'src/backend/executor/functions.c')
0 files changed, 0 insertions, 0 deletions