Re: Does exclusive locking improve performance?

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: Does exclusive locking improve performance?
Дата
Msg-id 20110217051835.GU4116@tamriel.snowman.net
обсуждение исходный текст
Ответ на Does exclusive locking improve performance?  (Jeremy Palmer <JPalmer@linz.govt.nz>)
Список pgsql-performance
* Jeremy Palmer (JPalmer@linz.govt.nz) wrote:
> In normal circumstances does locking a table in access exclusive mode improve insert, update and delete operation
performanceon that table. 
>
> Is MVCC disabled or somehow has less work to do?

MVCC certainly isn't disabled.  Does it have less work to do?  That's a
bit harder to say but my guess is "not so much that you'd actually be
able to notice it."..

    Thanks,

        Stephen

Вложения

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

Предыдущее
От: Jeremy Palmer
Дата:
Сообщение: Does exclusive locking improve performance?
Следующее
От: "Pierre C"
Дата:
Сообщение: Re: high user cpu, massive SELECTs, no io waiting problem