Hacker News new | ask | show | jobs
by ako 1279 days ago
Not as nice as oracle, oracle provides auto refreshed materialized views that will be updated with every commit.
2 comments
kabes 1279 days ago
https://www.postgresql.org/about/news/pg_ivm-10-released-244...
link
zozbot234 1278 days ago
Isn'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.
link