Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3864.500.181\))
Subject: Re: [BUG] false positive in bt_index_check in case of short 4B
 varlena datum
From: Andrey Borodin <x4mmm@yandex-team.ru>
In-Reply-To: <CAPpHfdsoVkyAwTr4E6pt0O42Cchxy3JuCzBWesxv03KmxAyP4A@mail.gmail.com>
Date: Mon, 4 May 2026 10:20:04 +0500
Cc: Andres Freund <andres@anarazel.de>,
 Alexander Lakhin <exclusion@gmail.com>,
 Michael Zhilin <m.zhilin@postgrespro.ru>,
 pgsql-bugs@postgresql.org,
 Yura Sokolov <y.sokolov@postgrespro.ru>
Content-Transfer-Encoding: 7bit
Message-Id: <13F0EC76-00B9-41D7-8EC3-D1F07FF7C66B@yandex-team.ru>
References: <c6f376bf-9896-111f-ccb1-a19dc1381ad0@gmail.com>
 <C8DD7CB5-CFE8-4AF5-88D7-B9F441BB5A8C@yandex-team.ru>
 <0b535249-a00c-a38a-85f6-d5a38c62dd55@gmail.com>
 <CAPpHfdsAs-B7O2_=jGbF+BQzuW3kGSboY9CcxzEOWUgxxZCr5Q@mail.gmail.com>
 <e3a78e44-ec6c-5924-7832-63de3aad3e9b@gmail.com>
 <CAPpHfdtZxhgjZTpaLd--dCxzUOL6tN+aAZPBeTsGKHLkMQAZpw@mail.gmail.com>
 <CAPpHfdu412Z+jh5Oyc1yzWFM0+52h0kSGQKV4=xQ0aT0UeY2BA@mail.gmail.com>
 <CAPpHfdspqdzVdEU2qHMibKn8OwVuLoZZYvKm-m5Ffqy2aMXgGQ@mail.gmail.com>
 <7ckc7oka4bvafkf5bwlqs6ygrhlsbhz25ppozfch7zbuxcx3rf@e4pr4oqenalc>
 <DA0695AB-4A40-4272-BE64-D22F81F7713B@yandex-team.ru>
 <c64tbgvkqu6v5y66lkitiy6dd32ksrwz3nysbclqnyztstx2lj@ymw4bqsf7zpv>
 <71E42FAF-FF92-4EE5-94A5-341EFB891281@yandex-team.ru>
 <CAPpHfdsoVkyAwTr4E6pt0O42Cchxy3JuCzBWesxv03KmxAyP4A@mail.gmail.com>
To: Alexander Korotkov <aekorotkov@gmail.com>
Archived-At: <https://www.postgresql.org/message-id/13F0EC76-00B9-41D7-8EC3-D1F07FF7C66B%40yandex-team.ru>
Precedence: bulk


> On 4 May 2026, at 00:44, Alexander Korotkov <aekorotkov@gmail.com> wrote:
> 
> AFAICS, this is correct.  However, I propose an alternative approach:
> use VARSIZE_ANY().  This might be a bit slower, but looks more
> intuitive to me.
Works for me.
However, I'd like to note that (VARSIZE_1B() < TOAST_INDEX_TARGET) is
constantly true for 8Kb+ pages.


Best regards, Andrey Borodin.