From: Will Hartung <willhartung@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Will Hartung <willhartung@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Loading table with indexed jsonb field is stalling
Date: Mon, 20 May 2019 11:17:47 -0700
Message-ID: <36F908DB-2F04-44F8-8C2E-7FD630882E0E@gmail.com> (raw)
In-Reply-To: <24634.1558375976@sss.pgh.pa.us>
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>
> On May 20, 2019, at 11:12 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> 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’ve moved the files around a little bit (not aggressively) and it still stalled, so I don’t think it’s something specific to the data. But we’ll have to play with it and see.
Thanks.
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-general@postgresql.org
Cc: willhartung@gmail.com, tgl@sss.pgh.pa.us, pgsql-general@lists.postgresql.org
Subject: Re: Loading table with indexed jsonb field is stalling
In-Reply-To: <36F908DB-2F04-44F8-8C2E-7FD630882E0E@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