sraoss/pg_ivm

Health v2 · maintenance only

Flags: no_license

Adoption not part of the score

1474 stars · 51 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

pg_ivm is a PostgreSQL extension implementing Incremental View Maintenance (IVM), which keeps materialized views up to date by applying only incremental changes instead of full recomputation. It provides a create_immv function that creates incrementally maintainable materialized views updated automatically via AFTER triggers on base tables.

Use cases

• keep materialized views up to date automatically in postgres
• avoid expensive REFRESH MATERIALIZED VIEW recomputation
• incrementally maintain views when base tables change
• create incrementally maintainable materialized views with create_immv
• speed up dashboards backed by materialized views
• maintain aggregate views efficiently on small data changes

When to choose

• you use PostgreSQL 13-19 and need always-fresh materialized views
• base tables change frequently but only small parts of the view are affected
• you want immediate view maintenance within the same transaction

When to avoid

• you need deferred or scheduled view maintenance rather than immediate updates
• you are not on PostgreSQL or cannot install C extensions
• your views change wholesale on every write, making recomputation cheaper

Facets

plugin · maturity active

database caching databases performance developer-tools windows postgresql-extension incremental-view-maintenance materialized-views immv c linux macos postgresql

Member repositories

For agents

markdown · JSON · MCP: product_card(name="sraoss/pg_ivm")