I had the pleasure on working on a fast refresh module for postgres something that is missing and we really needed for a project i was working on so in collaboration with AWS we managed to create this capability which is now in production and works very well, go take a read of the blog i wrote for AWS – https://go.aws/3gz5e2n

The open source repo is – https://github.com/CDLSoftware/pg-mv-fast-refresh