[direwolf20]

Materialised views don't work well in postgres. They don't incrementally update and have to be manually triggered to rebuild from scratch

[groundzeros2015]

Sure, I guess it depends on the use case.