Does exclusive locking improve performance?

Поиск
Список
Период
Сортировка
От Jeremy Palmer
Тема Does exclusive locking improve performance?
Дата
Msg-id 666FB8D75E95AE42965A0E76A5E5337E06D966C6FD@prdlsmmsg01.ad.linz.govt.nz
обсуждение исходный текст
Ответы Re: Does exclusive locking improve performance?  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-performance

In normal circumstances does locking a table in access exclusive mode improve insert, update and delete operation performance on that table.

 

Is MVCC disabled or somehow has less work to do?

 

Cheers

Jeremy


This message contains information, which is confidential and may be subject to legal privilege.
If you are not the intended recipient, you must not peruse, use, disseminate, distribute or copy this message.
If you have received this message in error, please notify us immediately (Phone 0800 665 463 or info@linz.govt.nz ) and destroy the original message.
LINZ accepts no responsibility for changes to this email, or for any attachments, after its transmission from LINZ.
 
Thank you.

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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Estimating hot data size
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: Does exclusive locking improve performance?