Re: BUG #17714: Refresh materialized view does not update all date - Mailing list pgsql-bugs

From Jeff Davis
Subject Re: BUG #17714: Refresh materialized view does not update all date
Date
Msg-id 9532f9b62c1a833b0f714223e031bb00e3752dde.camel@j-davis.com
Whole thread Raw
In response to BUG #17714: Refresh materialized view does not update all date  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
On Mon, 2022-12-12 at 10:34 +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
>
> Bug reference:      17714
> Logged by:          adarsh kumar
> Email address:      ext-adarsh.kumar@elisa.fi
> PostgreSQL version: 13.5
> Operating system:   Red Hat Enterprise Linux release 8.7 (Ootpa)
> Description:       
>
> We are using Materialized view in our environment and the updates
> seem to be
> incremental in nature, i.e. data older that a specific date is not
> getting
> updated.
> we tried manual refresh also , but it does not seem to resolve the
> issue.

Are you able to provide a self-contained illustration of the problem in
SQL?


--
Jeff Davis
PostgreSQL Contributor Team - AWS





pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: BUG #17715: dumps file raise an error on restore if a materialized view use a function calling another function
Next
From: Jean-Francois Levesque
Date:
Subject: Re: BUG #17710: Slow queries (100% CPU) after auto-vacuum