Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id C346D6503FF for ; Wed, 17 Dec 2008 16:01:02 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 46026-03 for ; Wed, 17 Dec 2008 16:00:59 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gx0-f16.google.com (mail-gx0-f16.google.com [209.85.217.16]) by mail.postgresql.org (Postfix) with ESMTP id BF87C6503F1 for ; Wed, 17 Dec 2008 16:00:59 -0400 (AST) Received: by gxk9 with SMTP id 9so49372gxk.19 for ; Wed, 17 Dec 2008 12:00:58 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=TW4hTSMD/BWjhdM6UTGOdjszHaNeUpyO2BcV6lxQqgM=; b=g2sXF1LiX+m5Dp4FHZa9Kmcd8+XX+BUgoq9E5JRp8YTinOUuAe1+WFop6vEmU5PDCc AY7fNRKyUobL7i257b/St1bayqp96EpBlIf9KvVsMm84lB2L3Ygw3CCuGtWblascz5s9 DyGU4CMawK3/PVkGNHyTV466pzGZ6XDmgdluY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=FckozUCZA+7gR7wFnUrr2oNR5uNX5IKCVwps5nOAt69NjSxVOmQ9+NArZpoBZfnjHt 5LB6sl5EYRQSlwpqhr95OZJadZx9sf/SGoAp/QS9PrmwJSvLTaPSh92RXcHUEip6YDIf YIVAVBQPuOPlDLJbbGxg/VaHUMQRnVXpc8khM= Received: by 10.151.142.16 with SMTP id u16mr1931601ybn.196.1229543954781; Wed, 17 Dec 2008 11:59:14 -0800 (PST) Received: by 10.150.211.9 with HTTP; Wed, 17 Dec 2008 11:59:14 -0800 (PST) Message-ID: <72dbd3150812171159t28806112l6470ef1327a2e8eb@mail.gmail.com> Date: Wed, 17 Dec 2008 11:59:14 -0800 From: "David Rees" To: "Nimesh Satam" Subject: Re: insert and Update slow after implementing slony. Cc: pgsql-performance@postgresql.org, nsatam@zedo.com, gauri@zedo.com, vidhya In-Reply-To: <965aa3ed0812162003w43bb3ad4la18898506c1f9ef@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <965aa3ed0812162003w43bb3ad4la18898506c1f9ef@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200812/167 X-Sequence-Number: 32203 On Tue, Dec 16, 2008 at 8:03 PM, Nimesh Satam wrote: > We are trying to implement slony as a replication tool for one of our > database. The Insert and updates have increased by approximately double > making some of our important script slow. What version of PostgreSQL are you running and on what type of hardware? I suspect that moving pg_log onto a separate spindle and/or upgrading your RAID controller to something with a BBU and configured in write-back mode would get most of your performance back. If you aren't running PostgreSQL 8.3, that might also help update performance significantly as well. -Dave