Re: [Postgres-xc-general] ERROR: Failed to get pooled connections

[Vladimir S. <vst...@gm...>]

On Mon, Jul 30, 2012 at 10:21:06PM +0900, Michael Paquier wrote:

>    - LB: There is an automatic load balancing between Datanodes and Coordinator by design. Load balancing at Coordinator
>    level has to be managed by an external tool.

For read requests to replicated tables and write requests to distributed
tables it is clear, it is true. But for write requests to replicated
tables there are no LB. And for read requests to distributed tables we
have quasi LB where requests for different data may go to different
nodes, while requests for the same data still go to the same node.

>      do You think about implementing different data node types (instead of
>      tables), i.e. "distributed" and "replicated" nodes?
> 
>    Well, the only extension that XC adds is that, and it allows to perform either read and/or write scalability in a
>    multi-master symmetric cluster, so that's a good deal!

I am not sure I understood You right. Does this means You support the
idea to move distribution type from table level to node level?

-- 

***************************
##  Vladimir Stavrinov
##  vst...@gm...
***************************