Re: Mat Views and Conflicts

On 2/20/24 05:25, Zahir Lalani wrote:
> -From: David G. Johnston <david.g.johnston@gmail.com>
> -Sent: Tuesday, February 20, 2024 1:20 PM
> -To: Zahir Lalani <ZahirLalani@oliver.agency>
> -Cc: Adrian Klaver <adrian.klaver@aklaver.com>; pgsql-general@lists.postgresql.org
> -Subject: Re: Mat Views and Conflicts
> -
> -
> -On Tuesday, February 20, 2024, Zahir Lalani <mailto:ZahirLalani@oliver.agency> wrote:
> -
> -This suggests that not all the MV data is cached and it still queries the source tables in some way?
> -
> -No.  That isn’t how MV work.  If you include an MV relation in your query from clause there is no reference or
knowledgeas to the underlying query that built the MV physical relation.
 
> -
> -David J.
> 
> Thx David
> 
> Cool so that is what my understanding was. But that comes back to my main question - the MV is cached data from the
lasttime refresh was run. If I query the MV and the underlying realtime data changes (i.e. from the source tables not
theMV)  - should I be getting a replication conflict issue? I would have thought not as the MV data should not have
beenimpacted
 

Then either something is running REFRESH MATERIALIZED VIEW or some other 
process is accessing the underlying tables.

> 
> Z

-- 
Adrian Klaver
adrian.klaver@aklaver.com