Hacker GitHub

← All repos

sraoss/pg_ivm

View on GitHub ↗ ★ 1,508 C

IVM (Incremental View Maintenance) implementation as a PostgreSQL extension

26 mentions on Hacker News by 26 people: 6 stories, 20 comments · first 2022-04-01 · latest 2025-10-02

Mentions per year 26 mentions · busiest year 2023 (8)
20082026
AllStoriesComments NewestTopOldest
  1. The pg_ivm plugin adds incremental updates to Postgresql materialized views: https://github.com/sraoss/pg_ivm Though I don't know how well it works on a write-heavy production db.
    comment by timbowhite · 2025-10-02 · in A SQL Heuristic: ORs Are Expensive
  2. Out of the box, you're right, but there are extensions that do just that: https://github.com/sraoss/pg_ivm It's however not available on RDS, so I've never had the chance to try it myself.
    comment by lbreakjai · 2025-08-24 · in Materialized views are obviously useful
  3. There is a PostgreSQL extension that adds support for incremental updates to materialised views: https://github.com/sraoss/pg_ivm
    comment by oftenwrong · 2025-08-24 · in Materialized views are obviously useful
  4. There's always the pg_ivm extension you can use in the meantime: https://github.com/sraoss/pg_ivm
    comment by whitepoplar · 2024-09-26 · in PostgreSQL 17
  5. …it depends on. It then uses pg_notify to watch for changes. The plan is to integrate pg_ivm ( https://github.com/sraoss/pg_ivm ) to make it even more efficient.
    comment by samwillis · 2024-08-12 · in Show HN: PGlite – in-browser WASM Postgres with pgvector and live sync
  6. …data without the performance hit of a REFRESH I wonder if they plan to incorporate something like https://github.com/sraoss/pg_ivm or write their own implementation. (Although I'm hopeful that one day we see ivm land in postgres core)
    comment by mnahkies · 2024-05-21 · in pg_timeseries: Open-source time-series extension for PostgreSQL
  7. …better if this were a Postgres extension instead. There are some efforts but still quite immature: https://github.com/sraoss/pg_ivm But at least Materialize does have Postgres wire compatibility, and same for Noria and MySQL. It's a plug &…
    comment by oersted · 2024-05-14 · in The notifier pattern for applications that use Postgres
  8. https://github.com/sraoss/pg_ivm
    comment by salojoo · 2024-03-15 · in Postgres is eating the database world
  9. https://github.com/sraoss/pg_ivm does what you need
    comment by serpix · 2024-03-15 · in Postgres is eating the database world
  10. I don't know about the support in core but there is this extension https://github.com/sraoss/pg_ivm
    comment by vira28 · 2024-02-23 · in Readyset: A MySQL and Postgres wire-compatible caching layer
  11. …MATERIALIZED VIEW command.” Article shows using the pg_ivm Postgres extension available here: https://github.com/sraoss/pg_ivm
    comment by Terretta · 2024-01-03 · in What Is Incremental View Maintenance (IVM)?
  12. This is being worked on if I recall: https://github.com/sraoss/pg_ivm
    comment by sseagull · 2023-08-29 · in Lesser Known Postgres Features (2021)
  13. …years but still not released! https://wiki.postgresql.org/wiki/Incremental_View_Maintenanc... https://github.com/sraoss/pg_ivm
    comment by garyclarke27 · 2023-05-25 · in PostgreSQL 16 Beta 1
  14. Maybe https://github.com/sraoss/pg_ivm might be of help?
    comment by mkleczek · 2023-01-29 · in Features I'd Like in PostgreSQL
  15. There’s awesome work being done on incremental view maintenance in postgres: https://github.com/sraoss/pg_ivm
    comment by hardwaresofton · 2023-01-01 · in Materialized View: SQL Queries on Steroids
  16. …is coming to PostgreSQL. For now that feature (from same contributor) is available as extension https://github.com/sraoss/pg_ivm
    comment by mirzap · 2023-01-01 · in Materialized View: SQL Queries on Steroids
  17. You might be interested in https://github.com/sraoss/pg_ivm
    comment by ivank · 2022-10-04 · in The next generation of Materialize
  18. …updated views is happening and progressing. For now, it's a separate extension, though: https://github.com/sraoss/pg_ivm . https://news.ycombinator.com/item?id=32098603
    comment by leeoniya · 2022-07-21 · in The data rules worth $40k a day
  19. …updated views is happening and progressing. For now, it's a separate extension, though: https://github.com/sraoss/pg_ivm .
    comment by gunnarmorling · 2022-07-14 · in PostgreSQL views and materialized views and how they influenced TimescaleDB
  20. …interested - in particular this section about the limitations is pretty interesting (and expected). https://github.com/sraoss/pg_ivm/#supported-view-definitions...
    comment by aidos · 2022-06-21 · in How we made data aggregation on PostgreSQL better and faster