On Tue, 1 Apr 2025 at 15:49, Kirill Reshke <reshkekir...@gmail.com> wrote: > > On Tue, 1 Apr 2025, 11:45 vignesh C, <vignes...@gmail.com> wrote: >> >> >> One thing I noticed was that if the materialized view is not refreshed >> user will get stale data >> >> Should we document this? > > Does this patch alter thus behaviour? User will get stale data even on HEAD, > why should we take a care within this thread?
We are not changing the existing behavior. However, since copying data from large tables can take a significant amount of time, would it be helpful to add a cautionary note advising users to refresh the materialized view before running copy command to avoid stale data? This could prevent users from realizing the issue only after running the copy operation, which would then require them to run it again. If you think this is already obvious, then the note may not be necessary. Regards, Vignesh
