Hello everyone,
In oracle we have user table sys.all_mviews which will have columns like staleness and compile_state which shows us whether data in MV is in sync with master tables or not and we can refresh MV if compile_state is not valid or staleness is not fresh or unknown . Is there any same way to do refresh of MV in Postgres without having triggers on master tables or scheduling refresh for every 2 hours or so. Please pour your suggestions.
Thanks