X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id E8F8B9DC801 for ; Thu, 16 Feb 2006 16:14:14 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 73482-09 for ; Thu, 16 Feb 2006 16:14:15 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id 5F0859DC874 for ; Thu, 16 Feb 2006 16:14:11 -0400 (AST) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Thu, 16 Feb 2006 20:14:13 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 16 Feb 2006 14:14:13 -0600 Subject: Re: Postgresql performance and tuning questions From: Scott Marlowe To: "Tomeh, Husam" Cc: "Given, Robert A" , Tom Lane , pgsql-admin@postgresql.org In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1140120852.22740.275.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Thu, 16 Feb 2006 14:14:13 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.159 required=5 tests=[AWL=0.158, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.159 X-Spam-Level: X-Archive-Number: 200602/204 X-Sequence-Number: 20625 On Thu, 2006-02-16 at 10:39, Tomeh, Husam wrote: > I do understand your school of thinking. But let me say this, from just > a user point of view who had used 7.4.x, 8.0, and 8.1, I'd highly > recommend to start off with 8.1. I can comment on performance in > particular among other great stuff such as scalability, robustness etc. > The performance in 8.1 compared with previous releases (even 8.0) is > remarkable and frankly like the difference between day and light, > specially when it comes to complex queries in large databases. From a > technical point of view, you can view the docs to find out more about > the great improvements with 8.1, such as > http://www.postgresql.org/docs/whatsnew And I'd like to add that of all the pieces of software I've ever used, none has consistently improved in terms of stability, performance, and features as well as the PostgreSQL project. Not one. It's the only project I've ever used that every new version has improved on all three of those areas every single time, and the gotchas from new versions have been small to non-existent. In fact, I'd say that bosses who were anti-new software versions have been far more of a problem than new versions of PostgreSQL has ever been. :) And I understand too, the aversion to new versions. I've been bitten by changes to new versions like php, apache, perl, java, and dozens of other packages. They are nothing like PostgreSQL.