Materialized views in pg with any incremental updates has timing inconsistencies that SQL Server doesn't have.