RE: COPY locking

Поиск
Список
Период
Сортировка
От Mikheev, Vadim
Тема RE: COPY locking
Дата
Msg-id 3705826352029646A3E91C53F7189E320165F5@sectorbase2.sectorbase.com
обсуждение исходный текст
Ответ на COPY locking  (John Coers <coers@intrinsity.com>)
Ответы Re: COPY locking
Список pgsql-general
> Hmm ... semops?  What platform are you on, anyway, and which
> PG version?
> It sounds like you might be running with the fallback SysV-semaphore-
> based implementation of spinlocks, which is orders of magnitude more

access/heap/hio.c:RelationGetBufferForRelation() uses LockPage
(ie lmgr -> semops) to syncronize table extending. Probably we could
optimize this somehow, but allocation of new page in bufmgr is
horrible and that's why we have locks in hio.c from the beginning.

Vadim

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

Предыдущее
От: "Ryan C. Bonham"
Дата:
Сообщение: RE: RE: MS SQL 7.0 to PostgreSQL 7.1
Следующее
От: Justin Clift
Дата:
Сообщение: Re: ER diagrams