Re: Naive handling of inequalities by nbtree initial positioning code

2023-08-13 Thread Peter Geoghegan
On Sun, Aug 13, 2023 at 5:50 PM Peter Geoghegan wrote: > All that it would take to fix the problem is per-attribute > BTScanInsertData.nextkey values. There is no reason why "nextkey" > semantics should only work for the last attribute in the insertion > scan key. Under this scheme, _bt_first() wo

Re: Naive handling of inequalities by nbtree initial positioning code

2023-08-13 Thread Peter Geoghegan
On Sun, Aug 13, 2023 at 5:50 PM Peter Geoghegan wrote: > select * from tenk1 > where > two = 1 > and four = 3 > and hundred = 91 > and thousand = 891 > and tenthous = 1891; > > The query returns one row, and touches 3 buffers/pages (according to > EXPLAIN ANALYZE with buffers). The overh