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 4B7848B9C27 for ; Mon, 31 Jan 2005 21:35:18 +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 60631-03 for ; Mon, 31 Jan 2005 21:35:09 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 9F5008B9C02 for ; Mon, 31 Jan 2005 21:35:08 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j0VLZ8rN004430; Mon, 31 Jan 2005 16:35:08 -0500 (EST) To: Cosimo Streppone Cc: Postgresql Performance list Subject: Re: High end server and storage for a PostgreSQL OLTP system In-reply-to: <41FE97FC.3060106@streppone.it> References: <41FE97FC.3060106@streppone.it> Comments: In-reply-to Cosimo Streppone message dated "Mon, 31 Jan 2005 21:41:32 +0100" Date: Mon, 31 Jan 2005 16:35:08 -0500 Message-ID: <4429.1107207308@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/639 X-Sequence-Number: 10329 Cosimo Streppone writes: > 1) What kind of performance gain can I expect switching from > 7.1 to 7.4 (or 8.0)? Obviously I'm doing my own testing, > but I'm not very impressed by 8.0 speed, may be I'm doing > testing on a low end server... Most people report a noticeable speedup in each new release; we hit different things in different releases, but usually at least one performance gain is useful to any one person. For a jump as far as from 7.1 to 8.0 I'm surprised that you're not seeing any gain at all. What was your test case exactly? Have you perhaps tuned your app so specifically to 7.1 that you need to detune it? regards, tom lane