4 ms·
Not as nice as oracle, oracle provides auto refreshed materialized views that will be updated with every commit.
by ako 4y ago
Not as nice as oracle, oracle provides auto refreshed materialized views that will be updated with every commit.
- kabes 4y agohttps://www.postgresql.org/about/news/pg_ivm-10-released-2443/ https://www.postgresql.org/about/news/pg_ivm-10-released-244...
- zozbot234 4y agoIsn't that better accomplished as an ordinary view + an index (arguably, an "auto-refreshed materialized" store is an index)? AIUI, Postgres supports indexes on arbitrary expressions.
- deleted 4y ago[deleted]