I have large centralized master database for which I created a few materialized views exclusively used by Web sites running in different regions on their own servers.
To avoid having to connect to and pull data from across the globe I am thinking about running small postgres instances in each region that only hold these materialized views. (trying to avoid Memcached, Redis)
Is there a way to refresh a materialized view across servers? Maybe using DB Link? What would be the most efficient way to keep these in sync?
Any suggestions? Would appreciate your thoughts on this.
