Horton

Re: BUG #18129: GiST index produces incorrect query results

Heikki Linnakangas <hlinnaka@iki.fi>

View thread View on postgr.es
From: Heikki Linnakangas <hlinnaka@iki.fi>
To: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org
Date: 2023-09-22T13:43:06Z
Lists: pgsql-bugs 
On 22/09/2023 09:00, PG Bug reporting form wrote:
> First bad commit is 9155580fd, on which three different outcomes are
> possible: test passes/test fails/assertion fails.
> Assertion failures, that we had observed after 9155580fd, were fixed by
> a7ee7c851 and 741b88435, but apparently there is another defect induced
> by that gist implementation change.

I can reproduce this. I suspect something's still wrong with the LSN <-> 
NSN cross check, when the pages are WAL logged in physical order. Thanks 
for the report, I'll take a look.

-- 
Heikki Linnakangas
Neon (https://neon.tech)

Commits

  1. Fix another bug in parent page splitting during GiST index build.