Friday, September 26, 2008

Re: [HACKERS] lock contention on parallel COPY ?

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

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

No comments: