Re: Mat Views and Conflicts

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