Re: Mat Views and Conflicts

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Zahir Lalani <ZahirLalani(at)oliver(dot)agency>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Mat Views and Conflicts
Date: 2024-02-20 13:19:45
Message-ID: CAKFQuwb-aUnZ6u_56b-+ZoOkeZij3WocXAqACPreqBsU_Eq+tg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tuesday, February 20, 2024, Zahir Lalani <ZahirLalani(at)oliver(dot)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 knowledge as to the underlying query
that built the MV physical relation.

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Zahir Lalani 2024-02-20 13:25:14 RE: Mat Views and Conflicts
Previous Message Patrick FICHE 2024-02-20 13:10:01 RE: array_to_json/array_agg question