For example, this is my source table What I want to do is to create a MV which asynchronously calculate the price difference whthin 30 min. And then, I can get the difference from this MV using an id every time. Here is an SQL example. It works correctly while directly execute it, but does not work while creating a
Tag: materialized-views
Emulating materialized views in PostgreSQL with concurrent refreshes
I’m using PostgreSQL 9.2.4 and would like to emulate a materialized view. Are there any well-known methods for doing this, including concurrent refreshes? Answer PostgreSQL wiki – materialized views links to two trigger-based implementations. The general idea is to put AFTER INSERT OR UPDATE OR DELETE … FOR EACH ROW triggers on each involved table that do partial updates on