Hi,
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.
Thanks
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.
Thanks
Alex
