On 10/6/2008 3:06 PM, Tony Fernandez wrote:
> My submission is a simple question. 
> Using Slony to replicate one Database into another, there is few Stored procedures that need to be loaded thru Slony.
> 

I think there is still a communication problem here. Are you talking 
about comments inside of PL/pgSQL stored procedures or are you talking 
about comments in slonik configuration scripts?


Jan

> How can I include Comment lines.
> 
> Also how can I comment a portion of a line and let execute all rest?
> 
> Thanks,
> 
> TonyF
> 
> -----Original Message-----
> From: slony1-hackers-bounces at lists.slony.info [mailto:slony1-hackers-bounces at lists.slony.info] On Behalf Of slony1-hackers-request at lists.slony.info
> Sent: Monday, October 06, 2008 3:00 PM
> To: slony1-hackers at lists.slony.info
> Subject: Slony1-hackers Digest, Vol 18, Issue 1
> 
> Send Slony1-hackers mailing list submissions to
> 	slony1-hackers at lists.slony.info
> 
> To subscribe or unsubscribe via the World Wide Web, visit
> 	http://lists.slony.info/mailman/listinfo/slony1-hackers
> or, via email, send a message with subject or body 'help' to
> 	slony1-hackers-request at lists.slony.info
> 
> You can reach the person managing the list at
> 	slony1-hackers-owner at lists.slony.info
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Slony1-hackers digest..."
> 
> 
> Today's Topics:
> 
>    1. Slony-I Communications Costs (Bernd Helmle)
>    2. Commented lines in Stored Procedures code uploaded	thru SLONY
>       (Tony Fernandez)
>    3. Re: Commented lines in Stored Procedures code	uploaded thru
>       SLONY (Christopher Browne)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Mon, 06 Oct 2008 13:42:30 +0200
> From: Bernd Helmle <mailings at oopsware.de>
> Subject: [Slony1-hackers] Slony-I Communications Costs
> To: slony1-hackers at lists.slony.info
> Message-ID: <932147FBA0722CEA5F821732 at imhotep.credativ.de>
> Content-Type: text/plain; charset=us-ascii; format=flowed
> 
> The Slony-I documentation states the following:
> 
> 
> "This points to it being a bad idea to have the large communications 
> network resulting from the number of nodes being large. Up to a half dozen 
> nodes seems pretty reasonable; every time the number of nodes doubles, this 
> can be expected to quadruple communications overheads."
> 
> Consider a setup with dozens of very small nodes which aren't heavliy 
> frequented. Neither of these nodes is considered to be a forwarder and 
> stores only information which aren't updated frequently (so we consider a 
> small database between 20 - 30 MB).  The Lagtime can be minutes (we don't 
> care wether 5 or 15 minutes). The network is stable.
> 
> I wonder wether the number of nodes can be significantly larger than the 
> half dozens the documentation mentions, especially if you don't need to use 
> Failover, MOVE SET and you are able to use high SYNC timeouts values. For 
> example, this can be configuration clusters of a large network where 
> configuration changes needs to be propagated through a large number of 
> nodes.
> 
> A customer is planning such a setup and they consider Slony-I exactly for 
> this purpose since they are impressed about its reliability. However, 
> because communications cost is quadratic, there can be significant network 
> traffic.
> 
> Opinions? Experiences?
> 


-- 
Anyone who trades liberty for security deserves neither
liberty nor security. -- Benjamin Franklin