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 1988156400 for ; Mon, 28 Feb 2005 21:47:12 +0000 (GMT) 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 65203-07 for ; Mon, 28 Feb 2005 21:47:10 +0000 (GMT) Received: from smtp3.libero.it (smtp3.libero.it [193.70.192.127]) by svr1.postgresql.org (Postfix) with ESMTP id 72389545F2 for ; Mon, 28 Feb 2005 21:47:06 +0000 (GMT) Received: from localhost (172.16.1.84) by smtp3.libero.it (7.0.027-DD01) id 42078669004E5FEE for pgsql-performance@postgresql.org; Mon, 28 Feb 2005 22:47:08 +0100 Received: from [62.98.85.112] (62.98.85.112) by smtp2.libero.it (7.0.027-DD01) (authenticated as tdezotti@inwind.it) id 41BF65E404BA07EC for pgsql-performance@postgresql.org; Mon, 28 Feb 2005 22:47:28 +0100 Message-ID: <42239156.6090108@streppone.it> Date: Mon, 28 Feb 2005 22:47:02 +0100 From: Cosimo Streppone User-Agent: Mozilla Thunderbird 0.9 (X11/20041103) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Postgresql Performance list Subject: Re: High end server and storage for a PostgreSQL OLTP system References: <6EE64EF3AB31D5448D0007DD34EEB3412A7603@Herge.rcsinc.local> <420141A8.2090800@streppone.it> In-Reply-To: <420141A8.2090800@streppone.it> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at libero.it serv5 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.153 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/374 X-Sequence-Number: 10703 Cosimo Streppone wrote: > Merlin Moncure wrote: > > > If everything is working the way it's supposed to, 8.0 should be faster > > than 7.1 (like, twice faster) for what you are probably trying to do. > > In the next days I will be testing the entire application with the > same database only changing the backend from 7.1 to 8.0, so this is > a somewhat perfect condition to have a "real-world" benchmark > of Pg 8.0 vs 7.1.x performances. The "next days" have come. I did a complete migration to Pg 8.0.1 from 7.1.3. It was a *huge* jump. The application is exactly the same, also the database structure is the same. I only dumped the entire 7.1.3 db, changed the backend version, and restored the data in the 8.0.1 db. The performance level of Pg 8 is at least *five* times higher (faster!) than 7.1.3 in "query-intensive" transactions, which is absolutely astounding. In my experience, Pg8 handles far better non-unique indexes with low cardinality built on numeric and integer types, which is very common in our application. -- Cosimo