Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D7EB69FB2B6 for ; Thu, 18 Jan 2007 01:35:17 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 02568-10 for ; Thu, 18 Jan 2007 01:35:15 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from proton.planetargon.com (proton.planetargon.com [198.145.37.35]) by postgresql.org (Postfix) with ESMTP id 9EDDB9FB2B4 for ; Thu, 18 Jan 2007 01:35:15 -0400 (AST) Received: from [172.16.1.106] (unknown [61.197.227.146]) by proton.planetargon.com (Postfix) with ESMTP id 9C2888D255E; Wed, 17 Jan 2007 21:35:14 -0800 (PST) In-Reply-To: <7e4ba9550701172119r6860bb05x561e1bba7a7657db@mail.gmail.com> References: <7e4ba9550701172043y62d76387sa95503c1a1daddc3@mail.gmail.com> <02B54F22-19AB-41F2-8E6B-11CB436A644D@seespotcode.net> <7e4ba9550701172119r6860bb05x561e1bba7a7657db@mail.gmail.com> Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <28D62C48-FF84-4258-A2A2-312AF1D1CB1F@seespotcode.net> Cc: pgsql-performance@postgresql.org Content-Transfer-Encoding: 7bit From: Michael Glaesemann Subject: Re: Version Change Date: Thu, 18 Jan 2007 14:35:12 +0900 To: "Gauri Kanekar" X-Mailer: Apple Mail (2.752.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/301 X-Sequence-Number: 22902 Please reply to the list so that others may contribute and benefit from the discussion. On Jan 18, 2007, at 14:19 , Gauri Kanekar wrote: > i want some comprehensive tests, to identify wheather shifiting > from 8.1.3 to 8.2 will be advantageous. I think it depends on your installation and use for PostgreSQL. PostgreSQL is used for many different types of projects which have different needs. I don't think it would be possible to put together some sort of comprehensive test suite that would answer your question. What I can recommend is benchmark common and performance critical tasks for your current 8.1.3 installation and then compare the results with those same benchmarks run against 8.2. Michael Glaesemann grzm seespotcode net