From: Alexander Lakhin <exclusion@gmail.com>
To: Heikki Linnakangas <hlinnaka@iki.fi>
To: Tender Wang <tndrwang@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18396: Assert in gistFindCorrectParent() fails on inserting large tuples into gist index
Date: Wed, 20 Mar 2024 08:00:00 +0300
Message-ID: <9c187e77-4e5f-949c-783f-f605ec5772ff@gmail.com> (raw)
In-Reply-To: <4af76123-c80a-4bd4-8674-47129093f227@iki.fi>
References: <18396-03cac9beb2f7aac3@postgresql.org>
<CAHewXN=FDqixMYCJXbdmH=P7GPBE_zH0HzQYkdSCxOtP6=VYiw@mail.gmail.com>
<4af76123-c80a-4bd4-8674-47129093f227@iki.fi>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: exclusion@gmail.com, hlinnaka@iki.fi, tndrwang@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18396: Assert in gistFindCorrectParent() fails on inserting large tuples into gist index
In-Reply-To: <9c187e77-4e5f-949c-783f-f605ec5772ff@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox