>
> 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.