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 crea…
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 DE…