COPY locking - Mailing list pgsql-general

From John Coers
Subject COPY locking
Date
Msg-id 3AF9BD09.2C89184@intrinsity.com
Whole thread Raw
Responses Re: COPY locking  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
What mode of locking is associated with a COPY to the database?

Is it a RowExclusiveLock and since it is brand new data, there should
be no conflicts?

I am trying to figure out what is slowing down multiple concurrent COPY
commands to my database and all I see is lots of semops.  CPU usage,
disk access, etc. are not pegged, so what else is could be slowing me down?


--
John Coers            Intrinsity, Inc.
coers@intrinsity.com  Austin, Texas

pgsql-general by date:

Previous
From: "Gordon Runkle"
Date:
Subject: RE: MS SQL 7.0 to PostgreSQL 7.1
Next
From: Tom Lane
Date:
Subject: Re: COPY locking