CODEWITHSUNDEEP
postgresqltimescaledb
hg628193hg
hg628193hg

Reputation: 495

can incremental view maintenance be used on postgresql13?

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?

Upvotes: 0

Views: 752

Answers (2)

Harsh Divecha
Harsh Divecha

Reputation: 1

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

Upvotes: 0

Laurenz Albe
Laurenz Albe

Reputation: 247270

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.

Upvotes: 1

Related Questions