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.
**********************************************************************************************
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
