BUG #17714: Refresh materialized view does not update all date

Started by PG Bug reporting formover 3 years ago2 messagesbugs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

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.
the underlying query of the materialized view, when run returns 1600 rows of
data but the refresed view contains only 269 rows of data and gets updated
when new data is updated.
After dropping the materialized view and recreating in test environment, the
subsequent updates run as expected.

#2Jeff Davis
pgsql@j-davis.com
In reply to: PG Bug reporting form (#1)
Re: BUG #17714: Refresh materialized view does not update all date

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