4 ms·

Postgres has it https://www.postgresql.org/docs/current/rules-materializedviews.html https://www.postgresql.org/docs/current/rules-materializedvi...

• ako 4y ago
  Not as nice as oracle, oracle provides auto refreshed materialized views that will be updated with every commit.
  • kabes 4y ago
    https://www.postgresql.org/about/news/pg_ivm-10-released-2443/ https://www.postgresql.org/about/news/pg_ivm-10-released-244...
  • zozbot234 4y 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.
  • deleted 4y ago
    [deleted]