Re: Bug in nbtree optimization to skip > operator comparisons (or < comparisons in backwards scans)

Alexander Korotkov <aekorotkov@gmail.com>

From: Alexander Korotkov <aekorotkov@gmail.com>

To: Pavel Borisov <pashkin.elfe@gmail.com>

Cc: Peter Geoghegan <pg@bowt.ie>, Heikki Linnakangas <hlinnaka@iki.fi>, Matthias van de Meent <boekewurm+postgres@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2023-12-27T12:36:18Z

Lists: pgsql-hackers

On Wed, Dec 27, 2023 at 1:18 PM Pavel Borisov <pashkin.elfe@gmail.com> wrote:
> Thank you for revised comments! I think they are good enough.

Pushed, thank you!

------
Regards,
Alexander Korotkov

Commits

Fix an oversight in refactoring in 06b10f80ba4.
- b670b93a66fc 17.0 landed
Make RangeTblEntry dump order consistent
- b4080fa3dcf6 17.0 cited
Improvements and fixes for e0b1ee17dc
- 7e6fb5da41d8 17.0 landed
Remove BTScanOpaqueData.firstPage
- 06b10f80ba4d 17.0 landed
Optimize nbtree backward scan boundary cases.
- c9c0589fda0e 17.0 cited
Skip checking of scan keys required for directional scan in B-tree
- e0b1ee17dc3a 17.0 cited