Re: Fully documenting the design of nbtree row comparison scan keys

Peter Geoghegan <pg@bowt.ie>

From: Peter Geoghegan <pg@bowt.ie>

To: Victor Yegorov <vyegorov@gmail.com>

Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2025-11-02T20:29:48Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Document nbtree row comparison design.
- b8f1c62807a5 19 (unreleased) landed
- 6c3b1df878a6 18.1 landed
Make row compares robust during nbtree array scans.
- bd3f59fdb717 19 (unreleased) cited
Fix incorrect handling of NULL index entries in indexed ROW() comparisons.
- a298a1e06fb0 9.6.0 cited

On Fri, Oct 31, 2025 at 1:40 PM Peter Geoghegan <pg@bowt.ie> wrote:
> On Fri, Oct 31, 2025 at 5:06 AM Victor Yegorov <vyegorov@gmail.com> wrote:
> > I took a look at the patch. Proposed comments look highly valuable, especially around NULLs, doesn't look immediately obvious, so definitely requires a comment.
> > Looks good to commit.
>
> Cool.

Pushed a cleaned up version of the patch just now.

Thanks
-- 
Peter Geoghegan