Fri Jan 26 06:37:19 PST 2007
- Previous message: [Slony1-general] PATCH: more explicitly recommend primary keys
- Next message: [Slony1-general] EXECUTE SCRIPT operates on non set member tables
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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.
**********************************************************************************************
- Previous message: [Slony1-general] PATCH: more explicitly recommend primary keys
- Next message: [Slony1-general] EXECUTE SCRIPT operates on non set member tables
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list