Request a Demo
Home   >   mailing lists

Re: Adding support for Row Compares to nbtree startikey optimization - Mailing list pgsql-hackers

From Chao Li
Subject Re: Adding support for Row Compares to nbtree startikey optimization
Date
Msg-id 304730E9-5F15-4B24-837F-3F5F74F81EAC@gmail.com
Whole thread Raw
In response to Re: Adding support for Row Compares to nbtree startikey optimization  (Chao Li <li.evan.chao@gmail.com>)
List pgsql-hackers
Tree view


On Aug 15, 2025, at 14:37, Chao Li <li.evan.chao@gmail.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/



pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Proposal: Conflict log history table for Logical Replication
Next
From: Michael Paquier
Date:
Subject: Re: Compilation issues for HASH_STATISTICS and HASH_DEBUG options