On 7/5/24 21:10, Peter J. Holzer wrote:
> If I understand https://github.com/sraoss/pg_ivm correctly, the
> materialized view will be updated within the same transaction. So it's
> just the same as any other change in the database:
>
> Neither client will wait for the other. The first client will see either
> the old or the new state depending on whether the second client manages
> to commit soon enough.
Thank you Peter.
So does that mean both the processes work concurrently?
I had understood that while an update is happening to an IVM (material
view ) the view is locked till the update is complete.
If so then how would both the clients have simultaneous access?
Regards.
>
>