Brinon Philippe p.brinon
Fri Jan 26 06:37:19 PST 2007
To Brad Nicholson:

1.	"Can I ask what you need 10 subscribers for?" The purpose of
this structure is to provide a series of database servers to be accessed
through web sites.
2.	"What slony processes are having a tremendous activity?" There
are around 20 PostGres processes which consume about 30% of the CPU. The
slon processes are not taking much CPU.
3.	"Which version of Slony are you using?" Version 1.1.1.5
4.	"Are you trying to optimize for the provider or the
subscribers?" For the provider. I understand your suggestion to use
cascade replicas. However, I'd like to understand why all this activity
is used even when the master DB is calm? (actually Christopher Browne
has given an answer to this question)
5.	"Which parameters is it possible to change in order to minimize
the activity?" You suggested setting forward='f'. I suppose you mean
defining each node like this:
    add_node(node     => 11,
             host     => 'geocat10',
             dbname   => 'geocatalogue',
             port     => 1521,
             user     => 'slony',
             password => '...',
             noforward => 'yes',
             parent   => 1);
which I have already done.

To Christopher Browne:

You suggest me to upgrade to version 1.2, which I will try to do next
week. I'll make my test first with "richly interconnected nodes" as you
say. Then I'll try with a minimum number of paths. And I'll let you know
the result.

Many thanks, Philippe Brinon.
**********************************************************************************************
Le contenu de cet e-mail et de ses pi?ces jointes est destin? ? l'usage exclusif du 
(des) destinataire(s) express?ment d?sign?(s) comme tel(s). En cas de r?ception de cet 
 e-mail par erreur, le signaler ? son exp?diteur et ne pas en divulguer le contenu. 
L'absence de virus a ?t? v?rifi? ? l'?mission du message. Il convient n?anmoins de 
v?rifier l'absence de corruption ? sa r?ception. The contents of this email and any attachments are 
confidential. They are intended for 
the named recipient(s) only. If you have received this email in error please notify the 
system manager or the sender immediately and do not disclose the contents to 
anyone or make copies. eSafe scanned this email for viruses, vandals and malicious 
content.
**********************************************************************************************




More information about the Slony1-general mailing list