| From: | Ravi Krishna <srkrishna1(at)aol(dot)com> |
|---|---|
| To: | "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: COPY threads |
| Date: | 2018-10-11 21:12:00 |
| Message-ID: | EA5CB1E5-9FA5-43FA-BA5B-C330AC6851A3@aol.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
>
> Well the result is not what I expected.
>
> this is the sql I used
>
> copy TEST.TABLE1 from '/var/lib/postgresql/data/rkrishna/copytesting/xaa' with delimiter '|' NULL as '' CSV HEADER;
>
> From another session
>
> copy TEST.TABLE1 from '/var/lib/postgresql/data/rkrishna/copytesting/xab' with delimiter '|' NULL as '' CSV HEADER;
>
> Each had 16M rows.
>
> I see that one copy is blocking other.
>
> The table has no indexes while loading.
>
> Aren't they suppose to run concurrently without locking ?
>
>
Strike that. The lock wait is bogus. The data did get loaded concurrently.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | legrand legrand | 2018-10-11 21:26:28 | no queryId in post_parse_analyze hook when row is locked |
| Previous Message | Ravi Krishna | 2018-10-11 21:08:19 | Re: COPY threads |