| From: | Michael Paquier <michael(at)paquier(dot)xyz> |
|---|---|
| To: | Yugo NAGATA <nagata(at)sraoss(dot)co(dot)jp> |
| Cc: | Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Richard Guo <guofenglinux(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: SI-read predicate locks on materialized views |
| Date: | 2022-12-01 06:48:21 |
| Message-ID: | Y4hONcD3AwvOqrmr@paquier.xyz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Naylor | 2022-12-01 07:00:43 | Re: [PoC] Improve dead tuple storage for lazy vacuum |
| Previous Message | Masahiko Sawada | 2022-12-01 06:13:26 | Re: Perform streaming logical transactions by background workers and parallel apply |