Replicating / Updating Materialized views across databases

Started by Alex Magnumalmost 3 years ago1 messagesgeneral
Jump to latest
#1Alex Magnum
magnum11200@gmail.com

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
Alex