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