Friday, September 26, 2008

Re: [HACKERS] lock contention on parallel COPY ?

Tom Lane wrote:
> Stefan Kaltenbrunner <> writes:
>> that one generates a huge amount of logs - output for ~60s into the load
>> is available here:
>> (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.


Sent via pgsql-hackers mailing list (
To make changes to your subscription:

No comments: