Re: SI-read predicate locks on materialized views

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: SI-read predicate locks on materialized views
Дата
Msg-id Y4hONcD3AwvOqrmr@paquier.xyz
обсуждение исходный текст
Ответ на Re: SI-read predicate locks on materialized views  (Yugo NAGATA <nagata@sraoss.co.jp>)
Ответы Re: SI-read predicate locks on materialized views  (Yugo NAGATA <nagata@sraoss.co.jp>)
Список pgsql-hackers
On Tue, Oct 18, 2022 at 05:29:58PM +0900, Yugo NAGATA wrote:
> Thank you for your review. I agree that an isolation test is required.
> The attached patch contains the test using the scenario as explained in
> the previous post.

Cool, thanks.  Sorry for my late reply here.  I have put my head on
that for a few hours and could not see why we should not allow that.
So committed the change after a few tweaks to the tests with the use
of custom permutations, mainly.

While looking at all that, I have looked at the past threads like [1],
just to note that this has never been really mentioned.

[1]: https://www.postgresql.org/message-id/1371225929.28496.YahooMailNeo@web162905.mail.bf1.yahoo.com
--
Michael

Вложения

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

Предыдущее
От: Masahiko Sawada
Дата:
Сообщение: Re: Perform streaming logical transactions by background workers and parallel apply
Следующее
От: John Naylor
Дата:
Сообщение: Re: [PoC] Improve dead tuple storage for lazy vacuum