Re: GiST multirange index scans can fail to return rows

From: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
To: Alexander Korotkov <aekorotkov(at)gmail(dot)com>
Cc: Kirill Reshke <reshkekirill(at)gmail(dot)com>, Peter Geoghegan <pg(at)bowt(dot)ie>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: GiST multirange index scans can fail to return rows
Date: 2026-08-20 09:37:18
Message-ID: 7B8A1FD9-131F-408A-B23C-15DA4730C5CE@yandex-team.ru
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On 2 Aug 2026, at 23:11, Alexander Korotkov <aekorotkov(at)gmail(dot)com> wrote:
>
> <v4-0001-Fix-GiST-contained-by-scans-of-multiranges.patch>

Hi Alexander,

I read v4 and think that the new predicate is correct.

This comment does not look perfect to me:

> Every multirange contains an infinite number of empty multiranges,
> even an empty one.

Perhaps just say "The empty multirange is contained by every multirange."

There's typo "multirage" in the commit message :)

Thank you!

Best regards, Andrey Borodin.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Kukushkin 2026-08-20 10:20:00 pg_dump: assert failure sorting casts/transforms
Previous Message Amit Kapila 2026-08-20 09:30:56 Re: Logical replication row filter loses unchanged toasted columns