Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 743042E3230 for ; Wed, 12 Dec 2007 10:45:16 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 43424-01-5 for ; Wed, 12 Dec 2007 10:45:02 -0400 (AST) Received: from cronos.madness.at (madness.at [217.196.146.217]) by postgresql.org (Postfix) with ESMTP id DF6AE2E02D1 for ; Wed, 12 Dec 2007 10:45:10 -0400 (AST) Received: from congw.dc1.conova.com ([217.196.145.250] helo=[192.168.1.61]) by cronos.madness.at with esmtpsa (TLS-1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.63) (envelope-from ) id 1J2SpZ-0002eD-8K; Wed, 12 Dec 2007 15:45:06 +0100 Message-ID: <475FF4BD.3000204@kaltenbrunner.cc> Date: Wed, 12 Dec 2007 15:48:29 +0100 From: Stefan Kaltenbrunner User-Agent: Icedove 1.5.0.14pre (X11/20071018) MIME-Version: 1.0 To: Harald Armin Massa CC: PostgreSQL Performance Subject: Re: URI to kind of a benchmark References: <7be3f35d0712120458y7a88d1bai8146d6e20ac4f7ab@mail.gmail.com> In-Reply-To: <7be3f35d0712120458y7a88d1bai8146d6e20ac4f7ab@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/180 X-Sequence-Number: 27996 Harald Armin Massa wrote: > reading postgres benchmarks for beginners advises to stop reading on the > words "default (ie. unchanged postgresql.conf); but the real test is > given right after: > > http://www.kaltenbrunner.cc/blog/index.php?/archives/21-guid.html > > That confirmes my first impression (on different workload) of "the speed > has doubled". > > If reality confirmes, that 8.2 to 8.3 will be a small step in versions, > and a great step in databases. yeah but keep in mind that this one only tested a very specific scenario (update heavy, workload fits easily in buffercache and benefits from HOT) - it is a fairly neat improvement though ... Stefan