Re: SI-read predicate locks on materialized views

Поиск
Список
Период
Сортировка
От Yugo NAGATA
Тема Re: SI-read predicate locks on materialized views
Дата
Msg-id 20221018172958.79d3ff51fe0c070af28d1ff7@sraoss.co.jp
обсуждение исходный текст
Ответ на Re: SI-read predicate locks on materialized views  (Michael Paquier <michael@paquier.xyz>)
Ответы Re: SI-read predicate locks on materialized views
Список pgsql-hackers
Hello Micheal-san,

On Thu, 13 Oct 2022 17:02:06 +0900
Michael Paquier <michael@paquier.xyz> wrote:

> On Fri, Sep 30, 2022 at 10:12:13AM +0900, Yugo NAGATA wrote:
> > Thank you for comment. Do you think it can be marked as Ready for Commiter?
> 
> Matviews have been discarded from needing predicate locks since
> 3bf3ab8 and their introduction, where there was no concurrent flavor
> of refresh yet.  Shouldn't this patch have at least an isolation test
> to show the difference in terms of read-write conflicts with some
> serializable transactions and REFRESH CONCURRENTLY?

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.

Regards,
Yugo Nagata

-- 
Yugo NAGATA <nagata@sraoss.co.jp>

Вложения

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

Предыдущее
От: Masahiko Sawada
Дата:
Сообщение: Re: TRAP: FailedAssertion("prev_first_lsn < cur_txn->first_lsn", File: "reorderbuffer.c", Line: 927, PID: 568639)
Следующее
От: Yugo NAGATA
Дата:
Сообщение: Re: make_ctags: use -I option to ignore pg_node_attr macro