Materialised views don't work well in postgres. They don't incrementally update and have to be manually triggered to rebuild from scratch
Sure, I guess it depends on the use case.