Postgres Pro
Downloads
Home   >   mailing lists

Re: lock contention on parallel COPY ? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: lock contention on parallel COPY ?
Date
Msg-id 22287.1222450976@sss.pgh.pa.us
Whole thread Raw
In response to Re: lock contention on parallel COPY ?  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Responses Re: lock contention on parallel COPY ?  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
List pgsql-hackers
Tree view 
Stefan Kaltenbrunner <stefan@kaltenbrunner.cc> writes:
> that one generates a huge amount of logs - output for ~60s into the load 
> is available here:
> http://www.kaltenbrunner.cc/files/lwstats.txt (21MB!)

Huh ... essentially all the contention is for OidGenLock.  I take it
you're loading into a table that has OIDs?
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Meridiem markers (was: [BUGS] Incorrect "invalid AM/PM string" error from to_timestamp)
Next
From: "Jonah H. Harris"
Date:
Subject: Re: PostgreSQL future ideas