Upcoming presentations
Materialized Views: Performance Shortcut or Operational Trap?
Materialized Views: Performance Shortcut or Operational Trap?
Materialized views are often the go-to solution for speeding up complex queries in PostgreSQL, especially for heavy joins and time-series aggregations. But while they can deliver impressive performance gains, they also introduce hidden operational costs—long refresh times, slower recovery, and increased fragility as data grows.
In this talk, we’ll walk through several real-world examples whe...
@ Postgres Conference: 2026
Ops