Re: [BUG] false positive in bt_index_check in case of short 4B varlena datum

From: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
To: Alexander Korotkov <aekorotkov(at)gmail(dot)com>
Cc: Andres Freund <andres(at)anarazel(dot)de>, Alexander Lakhin <exclusion(at)gmail(dot)com>, Michael Zhilin <m(dot)zhilin(at)postgrespro(dot)ru>, pgsql-bugs(at)postgresql(dot)org, Yura Sokolov <y(dot)sokolov(at)postgrespro(dot)ru>
Subject: Re: [BUG] false positive in bt_index_check in case of short 4B varlena datum
Date: 2026-05-04 05:20:04
Message-ID: 13F0EC76-00B9-41D7-8EC3-D1F07FF7C66B@yandex-team.ru
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> On 4 May 2026, at 00:44, Alexander Korotkov <aekorotkov(at)gmail(dot)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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Euler Taveira 2026-05-05 02:36:54 Re: BUG #19470: PostgreSQL backend aborts (assert failure) when a prepared statement returns a composite type cast t
Previous Message Alexander Korotkov 2026-05-03 19:44:32 Re: [BUG] false positive in bt_index_check in case of short 4B varlena datum