Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id AA455632FB4 for ; Wed, 31 Mar 2010 09:28:13 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 37095-04 for ; Wed, 31 Mar 2010 12:28:02 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outbound.afilias.info (outbound.afilias.info [69.46.124.26]) by mail.postgresql.org (Postfix) with ESMTP id 47089632789 for ; Wed, 31 Mar 2010 09:28:03 -0300 (ADT) Received: from ms6.yyz2.afilias-ops.info ([10.50.129.112] helo=smtp.afilias.info) by outbound.afilias.info with esmtp (Exim 4.69) (envelope-from ) id 1Nwx1Y-0003E4-90; Wed, 31 Mar 2010 12:27:56 +0000 Received: from tor-gateway.afilias.info ([199.15.87.4] helo=[10.10.46.12]) by smtp.afilias.info with esmtpsa (SSLv3:AES256-SHA:256) (Exim 4.69) (envelope-from ) id 1Nwx1Y-0005hT-8G; Wed, 31 Mar 2010 12:27:56 +0000 Subject: Re: Migrate postgres to newer hardware From: Brad Nicholson To: Renato Oliveira Cc: Scott Marlowe , Greg Smith , Tino Schwarze , "pgsql-admin@postgresql.org" In-Reply-To: <7965A9DCF12CC14984420BCC37B1608F25AB1AEF32@Elzar.grant.co.uk> References: <7965A9DCF12CC14984420BCC37B1608F25AB1AED49@Elzar.grant.co.uk> <1269959369.15416.5.camel@deimos> <20100330143831.GE17567@easy5.in-chemnitz.de> <7965A9DCF12CC14984420BCC37B1608F25AB1AEE54@Elzar.grant.co.uk> <4BB22F64.8080708@2ndquadrant.com> <7965A9DCF12CC14984420BCC37B1608F25AB1AEF03@Elzar.grant.co.uk> <7965A9DCF12CC14984420BCC37B1608F25AB1AEF32@Elzar.grant.co.uk> Content-Type: text/plain Date: Wed, 31 Mar 2010 08:27:56 -0400 Message-Id: <1270038476.5155.230.camel@bnicholson-desktop> Mime-Version: 1.0 X-Mailer: Evolution 2.26.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=-10 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 201003/285 X-Sequence-Number: 34084 On Wed, 2010-03-31 at 09:22 +0100, Renato Oliveira wrote: > Greg, > > I am going to gather the figures about our database and I will email to the list, if I am allowed to. > Number of tables, number of transactions per day etc. Absolutely allowed, and encouraged. Also, do you have long running transactions against the database? Are you committing large numbers of writes in a single transaction? > Nothing on our db servers are optimized, hardware wise, the db is on the same volume as logs as the os. > I know we have an IO problem because I have been checking it and it has been growing steadily. > We must migrate to newer and better optimized hardware. That will be your sticking point with Slony. If your IO system is already taxed, Slony will just add to the burden. -- Brad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp.