|
From: Ying He <yin...@ya...> - 2014-01-16 16:18:47
|
hi, All, After reviewing http://postgres-xc.sourceforge.net/misc-docs/PG-XC_Architecture.pdf and reading mailing list. two things concerns me:1. the gtm network overhead 2. postgres dml support in plpgsql 1. Is 100Gbit/s network a prerequisite for the following setup? If I plan to deploy a gtm master and slave on separate servers and 4 nodes of gtm_proxy, coordinator, datanodes and each will need to serve millions of transactions as daily volume. 2. Is there a doc that highlight which is currently not supported for postgres dml in plpgsql? Since the explain plan changes, i wonder how that affect postgres view predicate push and query performance.. The list will be important to consider postgres xc seriously because you can know what you need to change for your existing postgres setup. My main interest using postgres xc is its write scalability, all my tables will be replicated. It will be nice to see an updated PG-XC_Architecture.pdf which helps understand the internals. Thank you for your help. best, Ying |