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 21B50533B4 for ; Tue, 12 Apr 2005 13:37:12 -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 55973-04 for ; Tue, 12 Apr 2005 16:37:10 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id 967A7533D8 for ; Tue, 12 Apr 2005 13:37:10 -0300 (ADT) Received: from [192.168.1.52] (fc1smp [66.93.38.87]) (authenticated bits=0) by hosting.commandprompt.com (8.12.8/8.12.8) with ESMTP id j3CGWOma027784; Tue, 12 Apr 2005 09:32:25 -0700 Message-ID: <425BF92D.6060004@commandprompt.com> Date: Tue, 12 Apr 2005 09:37:01 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla Thunderbird 1.0.2-1.3.2 (X11/20050324) X-Accept-Language: en-us, en MIME-Version: 1.0 To: matt@followers.net Cc: pgsql-performance@postgresql.org Subject: Re: performance hit for replication References: <425bf664.1fac7adf.258a.5c79@mx.gmail.com> In-Reply-To: <425bf664.1fac7adf.258a.5c79@mx.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.028 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/237 X-Sequence-Number: 11634 >So, my question is this: My server currently works great, performance wise. >I need to add fail-over capability, but I'm afraid that introducing a >stressful task such as replication will hurt my server's performance. Is >there any foundation to my fears? I don't need to replicate the archived log >data because I can easily restore that in a separate step from the nightly >backup if disaster occurs. Also, my database load is largely selects. My >application works great with PostgreSQL 7.3 and 7.4, but I'm currently using >7.3. > >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. I am pretty sure Slony has similar capabilities. Sincerely, Joshua D. Drake