News for hackers. Stuff that matters.
Re:Lesser Known Postgres Features by paulddraper on Tuesday August 29, 2023 @02:42PM (#37312058)
"Incremental view maintenance"

Lots and lots of theory about how to do this correctly.

I authored a project to do this with triggers. https://github.com/rivethealth/denorm

Re:Lesser Known Postgres Features by jjgreen on Tuesday August 29, 2023 @03:00PM (#37312288)
Nice! I did this "by hand" for a dozen views a few years back, fiddly but rewarding; if I have to do it again ...