From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Zahir Lalani <ZahirLalani@oliver.agency>
To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Mat Views and Conflicts
Date: Mon, 19 Feb 2024 11:36:12 -0800
Message-ID: <c02bdeda-9ffb-42a5-8b6d-c13b9380f0fe@aklaver.com> (raw)
In-Reply-To: <AS8P251MB012075726CD81F97C586842CA7512@AS8P251MB0120.EURP251.PROD.OUTLOOK.COM>
References: <AS8P251MB012075726CD81F97C586842CA7512@AS8P251MB0120.EURP251.PROD.OUTLOOK.COM>
On 2/19/24 09:52, Zahir Lalani wrote:
> 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?
1) When you say '... ran the underlying query ...' are you referring to:
REFRESH MATERIALIZED VIEW
https://www.postgresql.org/docs/current/sql-refreshmaterializedview.html
2) What is the complete error message from the Postgres log?
>
> Have I got it wrong??
>
> Z
>
--
Adrian Klaver
adrian.klaver@aklaver.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: adrian.klaver@aklaver.com, ZahirLalani@oliver.agency
Subject: Re: Mat Views and Conflicts
In-Reply-To: <c02bdeda-9ffb-42a5-8b6d-c13b9380f0fe@aklaver.com>
References: <AS8P251MB012075726CD81F97C586842CA7512@AS8P251MB0120.EURP251.PROD.OUTLOOK.COM> <c02bdeda-9ffb-42a5-8b6d-c13b9380f0fe@aklaver.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox