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 18227.1222445424@sss.pgh.pa.us
Whole thread Raw
In response to lock contention on parallel COPY ?  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Responses Re: lock contention on parallel COPY ?  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Tree view 
Stefan Kaltenbrunner <stefan@kaltenbrunner.cc> writes:
> samples  %        symbol name
> 1933314  21.8884  LWLockAcquire
> 1677808  18.9957  XLogInsert
> 848227    9.6034  LWLockRelease
> 414179    4.6892  DoCopy
> 332633    3.7660  CopyReadLine
> 266580    3.0181  UnpinBuffer
> 221693    2.5099  heap_formtuple

I suppose Andrew didn't yet put in the hack to avoid WAL logging
during the COPY commands.  The LWLockAcquires are presumably
blocking on WALInsertLock, given that XLogInsert is also right
up there ...
        regards, tom lane

pgsql-hackers by date:

Previous
From: Stefan Kaltenbrunner
Date:
Subject: lock contention on parallel COPY ?
Next
From: Andrew Dunstan
Date:
Subject: Re: lock contention on parallel COPY ?