X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 21A01533E2 for ; Tue, 12 Apr 2005 13:55:47 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 62731-06 for ; Tue, 12 Apr 2005 16:55:44 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.197]) by svr1.postgresql.org (Postfix) with ESMTP id 60633533F8 for ; Tue, 12 Apr 2005 13:55:43 -0300 (ADT) Received: by rproxy.gmail.com with SMTP id j1so1436582rnf for ; Tue, 12 Apr 2005 09:55:44 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:reply-to:from:to:cc:subject:date:mime-version:content-type:content-transfer-encoding:x-mailer:in-reply-to:x-mimeole:thread-index:message-id; b=GSr3hmYgvQQFsfFKLnfkwN9Mlqf+YBRNtaVPwzO1HmiAcsGUnAbcSL7enMMfLVWcyxR8VcGRFkuYhF/iy+oq04iz3yf6JyduXDXiMDuSMjDHdIWCYTp3uKLgBkl2ty67g/iJp5GTGVSKq9+JmarGJjED8zLgNgQOkEBeKr/5f8Y= Received: by 10.38.150.39 with SMTP id x39mr5097057rnd; Tue, 12 Apr 2005 09:55:43 -0700 (PDT) Received: from MATTSPC ([12.216.69.41]) by mx.gmail.com with ESMTP id 73sm1446009rna.2005.04.12.09.55.43; Tue, 12 Apr 2005 09:55:43 -0700 (PDT) Reply-To: From: "Matthew Nuzum" To: "'Joshua D. Drake'" Cc: Subject: Re: performance hit for replication Date: Tue, 12 Apr 2005 11:55:40 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.6353 In-Reply-To: <425BF92D.6060004@commandprompt.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Thread-Index: AcU/fd/py30X0gUXS2iugSN2S/kfaAAAVRjg Message-ID: <425bfd8f.0ca3402b.339b.6cfe@mx.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.304 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200504/239 X-Sequence-Number: 11636 > >I'm eager to hear your thoughts and experiences, > > > > > Well with replicator you are going to take a pretty big hit initially > during the full > sync but then you could use batch replication and only replicate every > 2-3 hours. > > Sincerely, > > Joshua D. Drake > Thanks, I'm looking at your product and will contact you off list for more details soon. Out of curiosity, does batch mode produce a lighter load? Live updating will provide maximum data security, and I'm most interested in how it affects the server. -- Matthew Nuzum www.followers.net - Makers of "Elite Content Management System" Earn a commission of $100 - $750 by recommending Elite CMS. Visit http://www.elitecms.com/Contact_Us.partner for details.