Re: COPY locking - Mailing list pgsql-general

From Tom Lane
Subject Re: COPY locking
Date
Msg-id 4533.989450546@sss.pgh.pa.us
Whole thread Raw
In response to COPY locking  (John Coers <coers@intrinsity.com>)
List pgsql-general
John Coers <coers@intrinsity.com> 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

pgsql-general by date:

Previous
From: John Coers
Date:
Subject: COPY locking
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Metaphone function attachment