Sigh. OK. Can you point me to where exactly that code is? I see a delete
from sl_log_1 in cleanupThread_main, but I'm not sure when that gets
invoked? 

It just seems like you should be able to say that these 2 nodes
subscribe to the same set, but don't care about each other. It's
replication without failover semantics. I realize the log shipping is
designed to address this, but I'm not quite seeing why the listening
relationships could not be made lighter....

Of course, there's plenty that I don't understand, so I probably just
need to blunder around in the code for a while hurting myself before I
realize why things have to be the way they are!

Thanks.

- DAP

>-----Original Message-----
>From: Christopher Browne [mailto:cbbrowne at ca.afilias.info] 
>Sent: Thursday, January 27, 2005 4:09 PM
>To: David Parker
>Cc: slony1-general at gborg.postgresql.org
>Subject: Re: [Slony1-general] quadratic listener count growth
>
>"David Parker" <dparker at tazznetworks.com> writes:
>> Well I certainly look forward to hearing more about log 
>shipping, and 
>> paddling around with it when some building code is available.
>>
>> In the meantime, given that I have fairly short time-frame, I guess 
>> I'm back to my original question about these listeners:
>>
>> If I have a MASTER and subscribers A and B, and I know that 
>neither A 
>> nor B will ever become the set origin, do A and B strictly need to 
>> listen to each other? I see in the code where slon at 
>different points 
>> is waiting for syncs from other nodes, but I haven't figured out yet 
>> what bad thing happens if no listen record exists for a given node 
>> pair.
>
>Yeah, there is indeed a "bad thing."  
>
>You'll discover, if you do this, that since events from A 
>never make it to B, B gets no confirmation that A has 
>replicated what it ought to have, so B will never get around 
>to cleaning out old sl_log_1 entries.
>And vice-versa...
>
>This won't bite you on day 1, or necessarily by day 10.
>--
>"cbbrowne","@","ca.afilias.info"
><http://dev6.int.libertyrms.com/>
>Christopher Browne
>(416) 673-4124 (land)
>