Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id C479465055B for ; Tue, 22 Jul 2008 17:36:25 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 44483-04 for ; Tue, 22 Jul 2008 17:36:12 -0300 (ADT) Received: from mx3.hub.org (mx3.hub.org [206.223.169.73]) by postgresql.org (Postfix) with ESMTP id 8DBFB65059A for ; Tue, 22 Jul 2008 17:00:47 -0300 (ADT) X-Greylist: delayed 00:08:05.756856 by SQLgrey-1.7.6 Received: from westnet.com (westnet.com [216.187.52.2]) by mx3.hub.org (Postfix) with ESMTP id 3608937B4C0 for ; Tue, 22 Jul 2008 14:33:32 -0300 (ADT) Received: from westnet.com (localhost [127.0.0.1]) by westnet.com (8.14.0/8.14.0) with ESMTP id m6MHM0Ee012312; Tue, 22 Jul 2008 13:22:00 -0400 (EDT) Received: from localhost (gsmith@localhost) by westnet.com (8.14.0/8.13.2/Submit) with ESMTP id m6MHLxmP012305; Tue, 22 Jul 2008 13:21:59 -0400 (EDT) X-Authentication-Warning: westnet.com: gsmith owned process doing -bs Date: Tue, 22 Jul 2008 13:21:59 -0400 (EDT) From: Greg Smith X-X-Sender: gsmith@westnet.com To: Stephane Bailliez cc: pgsql-performance@postgresql.org Subject: Re: Performance on Sun Fire X4150 x64 (dd, bonnie++, pgbench) In-Reply-To: <48858230.8050906@gmail.com> Message-ID: References: <4881E9EF.5000805@gmail.com> <488460ED.8090001@gmail.com> <48858230.8050906@gmail.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed 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: 200807/209 X-Sequence-Number: 30809 On Tue, 22 Jul 2008, Stephane Bailliez wrote: > I'm 'migrating' (read entirely changing schemas, 'migrating' data) is > coming out from a 8.1.11 install. It is not a critical system. The > source data is always available from another system and the postgresql > system would be a 'client'. So if 8.2.x is so abysmal it should not even > be considered for install compared to 8.1.x and that only 8.3.x is > viable then ok that makes sense and I have to go the extra mile. 8.2 is a big improvement over the 8.1 you're on now, and 8.3 is a further improvement. If the system isn't critical, it doesn't sound like doing a later 8.2->8.3 upgrade (rather than going right to 8.3 now) will be a big deal for you. Just wanted you to be aware that upgrading larger installs gets tricky sometimes, so it's best to avoid that if you could just do more up-front work instead to start on a later version if practical. -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD