can incremental view maintenance be used on postgresql13?

Question

I'm currently using this timescaleDB integrated with postgresql13, I found this patch called incremental view maintenance which i think is also very important for my project

https://github.com/sraoss/pgsql-ivm

can pgsql-ivm be possibly be installed in postgresql13? So that I can use both of them at them same time?

Sanderson

Answer 1

That's probably a PostgreSQL version with this patch applied.

This has been under discussion for a while, but didn't make it into the source tree so far.

I wouldn't dare use that yet, unless I have good reason to trust the code and am ready to take care of that patch and apply it to PostgreSQL for each new update.

My advice is to roll your own using a regular table and triggers.

Philadelphia

I found this one. It seems much more mature? github.com/MaterializeInc/materialize – Sanderson

No idea (I didn't read the code). My advice stands. Asking for recommendations for tools is off-topic... – Philadelphia

Answer 2

They added support for older version it seems like https://www.postgresql.org/about/news/pg_ivm-17-released-2714/

Hammon