Video by FOSSASIA via YouTube
Keeping materialized views up to date can be expensive, especially when using full refresh operations. This session introduces pg_ivm, a PostgreSQL extension that enables Incremental View Maintenance (IVM) by applying only the data changes needed to update materialized views.
Learn how pg_ivm improves query performance and reduces refresh costs compared to traditional `REFRESH MATERIALIZED VIEW` operations. We’ll explore the extension’s architecture, real-world use cases, and recent enhancements, including new support for outer joins and ongoing development efforts.
Whether you’re a PostgreSQL DBA, database developer, or data engineer, this talk provides valuable insights into optimizing materialized views, improving analytics workloads, and scaling PostgreSQL more efficiently.
FOSSASIA Summit 2026 held in Bangkok, is Asia’s leading Open Source tech conference featuring sessions on #AI, #Cloud, #DevOps, #Open Hardware, #Security, #Web #Mobile Technologies, #Web3, and #Databases. Learn more: http://summit.fossasia.org
Session slide: https://eventyay.com/ev/88882f3e/talk/C9YQG9NHM51N/
#FOSSASIA #FOSSASIASummit #opensource #FOSS