Re: Adding support for Row Compares to nbtree startikey optimization

From: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Cc: Peter Geoghegan <pg(at)bowt(dot)ie>
Subject: Re: Adding support for Row Compares to nbtree startikey optimization
Date: 2025-08-15 06:57:25
Message-ID: 304730E9-5F15-4B24-837F-3F5F74F81EAC@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On Aug 15, 2025, at 14:37, Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com> wrote:
>
> When subkey->sk_attno <= firstchangingattnum, if first is not satisfied, then last should not be satisfied either, so we can skip check last.

Sorry for a typo, "subkey->sk_attno <= firstchangingattnum” should be "subkey->sk_attno < firstchangingattnum”. It should be “<“ but “<=“.

Chao Li (Evan)
--------------------
HighGo Software Co., Ltd.
https://www.highgo.com/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2025-08-15 07:09:09 Re: Compilation issues for HASH_STATISTICS and HASH_DEBUG options
Previous Message Amit Kapila 2025-08-15 06:52:32 Re: Proposal: Conflict log history table for Logical Replication