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

From Stefan Kaltenbrunner
Subject Re: lock contention on parallel COPY ?
Date
Msg-id 48DD217F.6040404@kaltenbrunner.cc
Whole thread Raw
In response to Re: lock contention on parallel COPY ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> 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?

hmm that particular database has its ancient roots on 7.3 (or 7.4) and 
indeed it seems that some tables in the dump are preceeded by a SET 
default_with_oids = true;

Will go and elimited those and try again.


Stefan


pgsql-hackers by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Re: PostgreSQL future ideas
Next
From: Simon Riggs
Date:
Subject: Re: lock contention on parallel COPY ?