Re: lock contention on parallel COPY ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: lock contention on parallel COPY ?
Date: 2008-09-26 16:10:24
Message-ID: 18227.1222445424@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2008-09-26 16:13:44 Re: lock contention on parallel COPY ?
Previous Message Stefan Kaltenbrunner 2008-09-26 16:03:20 lock contention on parallel COPY ?