On 11/1/2005 11:19 AM, Philippe Ferreira wrote:

>>1.  slon processes = 50 clusters x 2 nodes = 100 processes
>>
>>There will be... hmmm...  I think... 4 threads apiece, so the process
>>table would report 400 slon processes
>>
>>2.  Each of those threads will open at least one database connection. 
>>Those servicing subscriptions (there will be 50 of these) will open two
>>connections.
>>
>>That would mean 450 connections, ergo 450 postmaster backends.
>>
>>Unfortunately, yes, that will add up to rather a lot of processes :-(
>>  
>>
> Hi,
> 
> I think it will be worse, because each server would host a total of 100 
> databases (50 "master"
> + 50 "slave" databases) :
>  - Server "A" will be the master node for 50 databases, and "B" their 
> slave node.
>  - Server "B" will be the master node for 50 other databases, and "A" 
> their slave node.
> 
> Do you think it's a viable setup ?

Doesn't sound like what I had in mind when designing the system. It will 
be complicated to administer to say the least.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #