Tom Lane wrote:
Stefan Kaltenbrunner <[EMAIL PROTECTED]> 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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
