What are the advantages of Postgres-XL synchronization over PostgreSQL?

Question

PostgreSQL

For the first time I meet with the task of scaling a database to many nodes, so I know little about it. But there is a problem and it is necessary to solve it somehow. The nodes will be in each region, infa from them must be synchronized with the central server and the rest of the nodes.
I was advised to use Postgres-XL, but there is little information on it and from what I understood - there requests will go to the coordinator, and he will already decide which node to send the request to. Those. in each region, in addition to the node, you need to put a coordinator?
Maybe in this case it is more profitable to install regular Postgres?

Answer 1

In general, it would be nice if you painted the problem a little more in detail.
For example, what is the goal of diversifying db-servers by region (and how will work with them take place) the right to live...)

Answer 2

I think that Postgres-XL is not what you need. Judging by the description, I did not work with it, it is an analytical database for building OLAP, not OLTP. It is intended for data analysis and there can be quite large delays.