It’s only significant weakness now is in Materialized views, with their lack of incremental refresh.

That work towards incrementally updated views is happening and progressing. For now, it's a separate extension, though: https://github.com/sraoss/pg_ivm.

https://news.ycombinator.com/item?id=32098603