You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I am trying to determine whether the refresh_ivm function refreshes an incremental view manually. If it does, I also need to know if the refresh is performed incrementally.
Does it support deferred incremental maintenance?
Could you please provide insights or examples that clarify:
Whether refresh_ivm can be used to manually refresh an incremental view.
If the manual refresh is indeed incremental.
Any help or guidance on this would be greatly appreciated!
Whether refresh_ivm can be used to manually refresh an incremental view.
No. Currently, pg_ivm supports only immediate maintenance, that is, views can be incrementally updated in automatic way only when a underlying table is modified. I would like to support deferred maintenance that enables to update a view incrementally by executing refresh_immv command manually in future, but it is not implemented yet.
I am trying to determine whether the
refresh_ivm
function refreshes an incremental view manually. If it does, I also need to know if the refresh is performed incrementally.Does it support deferred incremental maintenance?
Could you please provide insights or examples that clarify:
refresh_ivm
can be used to manually refresh an incremental view.Any help or guidance on this would be greatly appreciated!
@Jamal-B, @yugo-n , @tatsuo-ishii , @hanefi
The text was updated successfully, but these errors were encountered: