Mat Views and Conflicts

From: Zahir Lalani <ZahirLalani(at)oliver(dot)agency>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Mat Views and Conflicts
Date: 2024-02-19 17:52:53
Message-ID: AS8P251MB012075726CD81F97C586842CA7512@AS8P251MB0120.EURP251.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All

My understanding and hope was that Mat Views cache their data and that is how they are so fast. But we are experience "cancelling statement due to conflict with recovery" errors on MV's with large data sets and I thought that this could only happen if we ran the underlying query, not the Mat View?

Have I got it wrong??

Z

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2024-02-19 18:13:12 Re: Mat Views and Conflicts
Previous Message Adrian Klaver 2024-02-19 17:17:12 Re: DETAIL: Could not open file "pg_xact/0EEA": No such file or directory