John Coers <[EMAIL PROTECTED]> writes:
> 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.
Are you talking about concurrent copies into the same table? That would
suffer a lot of short-term lock interference, no doubt, since all the
copies are going to be writing the same disk page (ie, the current last
page of the table).
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
