Y
Hacker News
new
|
ask
|
show
|
jobs
by
Justsignedup
1280 days ago
Postgres has it
https://www.postgresql.org/docs/current/rules-materializedvi...
1 comments
ako
1280 days ago
Not as nice as oracle, oracle provides auto refreshed materialized views that will be updated with every commit.
link
kabes
1280 days ago
https://www.postgresql.org/about/news/pg_ivm-10-released-244...
link
zozbot234
1280 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