Re: Hash index bucket split bug

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com>
Subject: Re: Hash index bucket split bug
Date: 2026-07-09 16:31:53
Message-ID: CAH2-Wz=qCx-2fpB0vec3fTGOnY8=mJ3O+6JY5V+V+mWDxV=fXQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Jul 9, 2026 at 11:24 AM Peter Geoghegan <pg(at)bowt(dot)ie> wrote:
> Attached v2 has a more stable version of the isolation test (no other
> changes compared to V1). Does this version work for you?

I ran this against CI, and saw failures on 32-bit meson tied to tuple
alignment. When MAXALIGN is 4, the assumptions about page layout
underlying the test case break.

Attached is V3, which directly addresses the alignment issue, and
fully passes CI.

--
Peter Geoghegan

Attachment Content-Type Size
v3-0001-Fix-hash-index-scans-concurrent-with-bucket-split.patch application/x-patch 2.7 KB
v3-0002-Add-tests-for-hash-index-scans-concurrent-with-bu.patch application/x-patch 18.4 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jacob Champion 2026-07-09 16:58:30 Re: PG20 Minimum Dependency Thread
Previous Message Thom Brown 2026-07-09 16:11:32 Re: SQL/JSON json_table plan clause