Message-ID: <9c187e77-4e5f-949c-783f-f605ec5772ff@gmail.com>
Date: Wed, 20 Mar 2024 08:00:00 +0300
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.4.2
Subject: Re: BUG #18396: Assert in gistFindCorrectParent() fails on inserting
 large tuples into gist index
Content-Language: en-US
To: Heikki Linnakangas <hlinnaka@iki.fi>, Tender Wang <tndrwang@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
References: <18396-03cac9beb2f7aac3@postgresql.org>
 <CAHewXN=FDqixMYCJXbdmH=P7GPBE_zH0HzQYkdSCxOtP6=VYiw@mail.gmail.com>
 <4af76123-c80a-4bd4-8674-47129093f227@iki.fi>
From: Alexander Lakhin <exclusion@gmail.com>
In-Reply-To: <4af76123-c80a-4bd4-8674-47129093f227@iki.fi>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/9c187e77-4e5f-949c-783f-f605ec5772ff%40gmail.com>
Precedence: bulk

Hello Heikki and Tender Wang,

19.03.2024 17:26, Heikki Linnakangas wrote:
> On 19/03/2024 14:07, Tender Wang wrote:
>> Thanks for your report. I can reproduce this issue.
>> I try to delete the Assert, no coredump anymore.
>> I need some time to learn GiST to find the root cause.
>
> If you're interested to work on this, Tender, maybe you can figure that out?
>

Thank you for looking at this!

I'm also bothered by errors "no empty local buffer available" produced
(on master, but not on REL_12_STABLE) when inserting larger tuples:
INSERT INTO t SELECT '' FROM generate_series(1, 500) g;
INSERT INTO t SELECT
  (SELECT string_agg('text' || g, ' ') FROM generate_series(1, 700) g)
  FROM generate_series(1, 30);

Are those errors expected?

Best regards,
Alexander