Content-Type: text/plain; charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 9.3 \(3124\))
Subject: Re: Loading table with indexed jsonb field is stalling
From: Will Hartung <willhartung@gmail.com>
In-Reply-To: <24634.1558375976@sss.pgh.pa.us>
Date: Mon, 20 May 2019 11:17:47 -0700
Cc: Will Hartung <willhartung@gmail.com>,
 pgsql-general@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <36F908DB-2F04-44F8-8C2E-7FD630882E0E@gmail.com>
References: 
 <CAKMEDdxE95SC76wadMzrH454HpvCV4tOdEmuZRO=pwArEw6YVg@mail.gmail.com>
 <20505.1558202555@sss.pgh.pa.us>
 <90835D2B-1FBA-4F26-8157-7C831C24B266@gmail.com>
 <24634.1558375976@sss.pgh.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Precedence: bulk


> On May 20, 2019, at 11:12 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>=20
> Hmm, so not a deadlock (plus you're running a version that has that
> bug fixed).  It sounds like you might have hit an actual bug, perhaps
> one that causes it to endlessly re-split an index page, or something
> along that line.  But it's going to be hard to find the cause without
> a test case.  I don't suppose you can anonymize your data to the
> point where you'd have a publishable test case?

That would take some time, thankfully it seems reproducible with a few =
million rows.

I=E2=80=99ve moved the files around a little bit (not aggressively) and =
it still stalled, so I don=E2=80=99t think it=E2=80=99s something =
specific to the data. But we=E2=80=99ll have to play with it and see.

Thanks.