From: | Will Hartung <willhartung(at)gmail(dot)com> |
---|---|
To: | Tim Cross <theophilusx(at)gmail(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Loading table with indexed jsonb field is stalling |
Date: | 2019-05-20 18:03:25 |
Message-ID: | 78E7AB8C-999A-45E7-AB12-639CE65436A3@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Will Hartung | 2019-05-20 18:04:53 | Re: Loading table with indexed jsonb field is stalling |
Previous Message | Adrian Klaver | 2019-05-20 17:41:44 | Re: Loading table with indexed jsonb field is stalling |