Re: Bug in nbtree optimization to skip > operator comparisons (or < comparisons in backwards scans) - Mailing list pgsql-hackers

From Anton A. Melnikov
Subject Re: Bug in nbtree optimization to skip > operator comparisons (or < comparisons in backwards scans)
Date
Msg-id 30cd7524-b9f1-4cf8-9c4a-223eb2e34441@postgrespro.ru
Whole thread Raw
In response to Re: Bug in nbtree optimization to skip > operator comparisons (or < comparisons in backwards scans)  (Alexander Korotkov <aekorotkov@gmail.com>)
Responses Re: Bug in nbtree optimization to skip > operator comparisons (or < comparisons in backwards scans)
List pgsql-hackers
Hi!

Maybe _bt_readpage(scan, dir, start, true) needed at this line:


https://github.com/postgres/postgres/blob/b4080fa3dcf6c6359e542169e0e81a0662c53ba8/src/backend/access/nbtree/nbtsearch.c#L2501

?

Do we really need to try prechecking the continuescan flag here?

And the current "false" in the last arg does not match the previous code before 06b10f80ba
and the current comment above.

Would be very grateful for clarification.

With the best regards!

-- 
Anton A. Melnikov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company



pgsql-hackers by date:

Previous
From: Bertrand Drouvot
Date:
Subject: Re: Introduce XID age and inactive timeout based replication slot invalidation
Next
From: Pavel Borisov
Date:
Subject: Re: Bug in nbtree optimization to skip > operator comparisons (or < comparisons in backwards scans)