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?
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.