Re: SSI and predicate locks - a non-trivial use case

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: SSI and predicate locks - a non-trivial use case
Дата
Msg-id 1377958746.95936.YahooMailNeo@web162906.mail.bf1.yahoo.com
обсуждение исходный текст
Ответ на Re: SSI and predicate locks - a non-trivial use case  (Kevin Grittner <kgrittn@ymail.com>)
Список pgsql-general
Дерево обсуждения 
Kevin Grittner <kgrittn@ymail.com> wrote:

>  - We don't distinguish between heap relation locks which need to

> prohibit inserts (those caused by a table scan) and heap relation
> locks which don't conflict with inserts (those caused by promotion
> from finer granularity).  We would reduce false positives if we
> did.


Correction: in the above point "prohibit" is misleading.

s/prohibit/cause read-write conflicts with/


A single read-write conflict does not cause blocking or transaction rollback.


--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

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

Предыдущее
От: Kevin Grittner
Дата:
Сообщение: Re: SSI and predicate locks - a non-trivial use case
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: My Experiment of PG crash when dealing with huge amount of data