>>>
>> Thank you. Let me test it and see the benefit. We have a use case for this.
>
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 ?