Editorial question83.8K views2,763 votes0 answers1,471 following
AI-generatedREFRESH ON COMMIT in Phoenix 5.0: When Does the MV Refresh Execute Relative to Commit?
Phoenix 5.0 added the REFRESH ON COMMIT option to CREATE MATERIALIZED VIEW , enabling automatic view refresh after each transaction that modifies the base table. The intended behavior is that the view should be refreshed after the transaction that caused the change commits. The goal is to pin down the exact moment the refresh operation runs: does it occur be