Re: COPY locking

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: coers(at)intrinsity(dot)com
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: COPY locking
Date: 2001-05-09 23:22:26
Message-ID: 4533.989450546@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

John Coers <coers(at)intrinsity(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Justin Clift 2001-05-09 23:38:23 Re: Oracle to Pg tool
Previous Message Bruce Momjian 2001-05-09 23:00:33 Re: [HACKERS] Metaphone function attachment