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