pg.ddx.io  pgsql-general@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: Loading table with indexed jsonb field is stalling
Date: Mon, 20 May 2019 18:27:07 -0500
Message-ID: <71e50367-2375-86a8-f795-97c894728998@gmail.com> (raw)
In-Reply-To: <3EF519CA-17FE-4B68-8B7A-78200E0A408F@gmail.com>
References: <CAKMEDdxE95SC76wadMzrH454HpvCV4tOdEmuZRO=pwArEw6YVg@mail.gmail.com>
	<20505.1558202555@sss.pgh.pa.us>
	<90835D2B-1FBA-4F26-8157-7C831C24B266@gmail.com>
	<cdc049f0-1980-f5a8-726a-629345b41ef0@aklaver.com>
	<3A35A039-D8F5-4B40-9B41-42E70BEF2C2E@gmail.com>
	<806d4915-f05d-8e75-0a42-e11b48596ab5@gmail.com>
	<12E9FEDD-37E9-4D51-9BA7-94FF5039BB1B@gmail.com>
	<563e995f-d7b1-7e2f-c1f1-b00db7a18589@gmail.com>
	<3EF519CA-17FE-4B68-8B7A-78200E0A408F@gmail.com>

On 5/20/19 5:43 PM, Will Hartung wrote:
>> On May 20, 2019, at 2:55 PM, Ron <ronljohnsonjr@gmail.com> wrote:
>>
>> And it pathologically loads even when there's just a PK on the numeric field?
> Yea, that works fine.
>
>> Drop all indexes, load data, recreate indexes?
> No, I use the incremental load as it gives a much better indication when the process has gone off the deep end.

That's fine for tracing errors in a test environment, but.

>> But pg_restore only creates indexes AFTER the data loads.
> Yes. Demonstrating that it doesn’t work either incrementally or all at once.
>
> (No, I have no confidence that the Aurora build will ever finish in any reasonable amount of time.)

I'm confused.  You wrote above that loading without indexes and with just 
the PK works just fine; if you *really* need it loaded in Aurora or 
production, just drop the indexes beforehand?

-- 
Angular momentum makes the world go 'round.

view thread (30+ messages)  latest in thread

Message-ID: <71e50367-2375-86a8-f795-97c894728998@gmail.com>
Permalink:  ../71e50367-2375-86a8-f795-97c894728998@gmail.com/
Also on:    postgresql.org/message-id/71e50367-2375-86a8-f795-97c894728998@gmail.com

 · 

reply
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: ronljohnsonjr@gmail.com, pgsql-general@lists.postgresql.org
  Subject: Re: Loading table with indexed jsonb field is stalling
  In-Reply-To: <71e50367-2375-86a8-f795-97c894728998@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