Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 05EC6633A9B for ; Wed, 31 Mar 2010 13:47:57 -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 78806-03 for ; Wed, 31 Mar 2010 16:47:46 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.17.8]) by mail.postgresql.org (Postfix) with ESMTP id 61B976336CC for ; Wed, 31 Mar 2010 13:47:46 -0300 (ADT) Received: from [75.194.114.255] ([75.194.114.255]) by mrelayeu.kundenserver.de (node=mrbap2) with ESMTP (Nemesis) id 0MT6qE-1O6GDr0Yis-00RcX4; Wed, 31 Mar 2010 18:47:44 +0200 Message-ID: <4BB37CAA.90606@2ndquadrant.com> Date: Wed, 31 Mar 2010 12:47:38 -0400 From: Greg Smith User-Agent: Thunderbird 2.0.0.24 (X11/20100317) MIME-Version: 1.0 To: Renato Oliveira CC: Scott Marlowe , Tino Schwarze , "pgsql-admin@postgresql.org" Subject: Re: Migrate postgres to newer hardware 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> In-Reply-To: <7965A9DCF12CC14984420BCC37B1608F25AB1AEF32@Elzar.grant.co.uk> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V01U2FsdGVkX1/SEbk+yqYlX52JTb2PcH8BnCe5it0N6RX1j9u mgKCa8lqEoVnij1KQr6SAt1wlAYbRxinWj6Rlx/xn3DOUe/QMo dhD9KmLHilIg8GpABhQ1CmtWnVlUlGW X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.11 tagged_above=-10 required=5 tests=BAYES_05=-1.11 X-Spam-Level: X-Archive-Number: 201003/291 X-Sequence-Number: 34090 Renato Oliveira wrote: > 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. > A quick snapshot from "vmstat 1" during a busy time is also very helpful. -- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support greg@2ndQuadrant.com www.2ndQuadrant.us