Re: COPY locking

Поиск
Список
Период
Сортировка
От John Coers
Тема Re: COPY locking
Дата
Msg-id 3AFB087C.1FBB9C5F@intrinsity.com
обсуждение исходный текст
Ответ на RE: COPY locking  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
Список pgsql-general
Tom Lane wrote:
>
> "Mikheev, Vadim" <vmikheev@SECTORBASE.COM> writes:
> > access/heap/hio.c:RelationGetBufferForRelation() uses LockPage
> > (ie lmgr -> semops) to syncronize table extending.
>
> But no semop should occur unless somebody is actually blocking on
> the lock.  John's trace only showed one active backend, so I figured
> that there shouldn't be any blockage.

Keep in mind that I only sent a sample of trace data to show the kind of
things I was seeing, not the entire process from end-to-end.

--
John Coers            Intrinsity, Inc.
coers@intrinsity.com  Austin, Texas

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Re: Query not using index
Следующее
От: "Mikheev, Vadim"
Дата:
Сообщение: RE: COPY locking