Postgres Pro
Downloads
Home   >   mailing lists

Re: Loading table with indexed jsonb field is stalling - Mailing list pgsql-general

From Will Hartung
Subject Re: Loading table with indexed jsonb field is stalling
Date
Msg-id 78E7AB8C-999A-45E7-AB12-639CE65436A3@gmail.com
Whole thread Raw
In response to Re: Loading table with indexed jsonb field is stalling  (Tim Cross <theophilusx@gmail.com>)
List pgsql-general
Tree view
I sent these earlier, but they didn’t get to the list, so I’m resending — sorry about that.

On May 17, 2019, at 7:53 PM, Tim Cross <theophilusx@gmail.com> wrote:

Which version of postgres?

 PostgreSQL 10.8 (Ubuntu 10.8-0ubuntu0.18.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.3.0-16ubuntu3) 7.3.0, 64-bit


How are you loading the data? (application, psql, pg_restore) using
(insert, copy)?


I have a SQL file I’m using filled with statements like:

\copy eis_entity from program 'gzcat /u2/hdhdata/xxx/out1000.txt.gz';
select now();
\copy eis_entity from program 'gzcat /u2/hdhdata/xxx/out1001.txt.gz';
select now();

Thanks

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Loading table with indexed jsonb field is stalling
Next
From: Will Hartung
Date:
Subject: Re: Loading table with indexed jsonb field is stalling