Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 01A1E9FB285 for ; Thu, 26 Jul 2007 16:04:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 10158-02 for ; Thu, 26 Jul 2007 16:04:06 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 8E9999FB3FA for ; Thu, 26 Jul 2007 16:04:05 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 6390C31418; Thu, 26 Jul 2007 21:04:04 +0200 (MET DST) From: Chris Browne X-Newsgroups: pgsql.performance Subject: Re: performance of postgresql in replication using slony Date: Thu, 26 Jul 2007 14:28:12 -0400 Organization: cbbrowne Computing Inc Lines: 42 Message-ID: <60r6mv58ar.fsf@dba2.int.libertyrms.com> References: <680184.79576.qm@web56612.mail.re3.yahoo.com> <1185470505.10167.16.camel@dogma.ljc.laika.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.20 (linux) Cancel-Lock: sha1:9SZC5pmDq0qkoRXwbMMhfkTqv4c= To: pgsql-performance@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.257 tagged_above=0 required=5 tests=AWL=-0.505, BAYES_50=0.001, FS_REPLICA=1.041, SARE_SPEC_REPLICA=0.72 X-Spam-Level: * X-Archive-Number: 200707/371 X-Sequence-Number: 26055 pgsql@j-davis.com (Jeff Davis) writes: > On Thu, 2007-07-26 at 01:44 -0700, angga erwina wrote: >> Hi all, >> whats the benefits of replication by using slony in >> postgresql?? >> My office is separate in several difference place..its >> about hundreds branch office in the difference >> place..so any one can help me to replicate our dbase >> by using slony?? and why slony?? >> > > This question should be asked on the slony1-general list, you'll get > more responses there. > > The benefit of using slony is that you can read from many servers rather > than just one. Indeed. It would be worth taking a peek at the documentation, notably the introductory material, as that will give some idea as to whether Slony-I is suitable at all for the desired purpose. One thing that "tweaks" my antennae a bit is the mention of having "hundreds branch office"; there are two things worth mentioning that would be relevant to that: - Slony-I is a single-master replication system, *not* a multimaster system. If someone is expecting to do updates at branch offices, and that this will propagate everywhere, that is likely not to work out easily or well. - If it *is* fair to assess that there will only be one "master", Slony-I is intended to support a relatively limited number of nodes. There are no absolute restrictions on numbers of subscribers, but there are enough communications costs that grow in a polynomial fashion that I would be quite disinclined to have more than a dozen nodes in a cluster. -- (reverse (concatenate 'string "ofni.sesabatadxunil" "@" "enworbbc")) http://www3.sympatico.ca/cbbrowne/slony.html HELP! I'm being attacked by a tenured professor!