Postgres Pro
Downloads
Home   >   mailing lists

Re: SI-read predicate locks on materialized views - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: SI-read predicate locks on materialized views
Date
Msg-id Y0fF/pd6FSU6Nk3m@paquier.xyz
Whole thread Raw
In response to Re: SI-read predicate locks on materialized views  (Yugo NAGATA <nagata@sraoss.co.jp>)
Responses Re: SI-read predicate locks on materialized views  (Yugo NAGATA <nagata@sraoss.co.jp>)
List pgsql-hackers
Tree view 
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?
--
Michael
Attachment

pgsql-hackers by date:

Previous
From: Bharath Rupireddy
Date:
Subject: Re: pg_receivewal fail to streams when the partial file to write is not fully initialized present in the wal receiver directory
Next
From: Amit Langote
Date:
Subject: Re: ExecRTCheckPerms() and many prunable partitions