Re: lock contention on parallel COPY ?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: lock contention on parallel COPY ?
Дата
Msg-id 18227.1222445424@sss.pgh.pa.us
обсуждение исходный текст
Ответ на lock contention on parallel COPY ?  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
Ответы Re: lock contention on parallel COPY ?
Список pgsql-hackers
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 по дате отправления:

Предыдущее
От: Stefan Kaltenbrunner
Дата:
Сообщение: lock contention on parallel COPY ?
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: lock contention on parallel COPY ?