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
Есть вопросы? Напишите нам!
Соглашаюсь с условиями обработки персональных данных
✖
By continuing to browse this website, you agree to the use of cookies. Go to Privacy Policy.