X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id B65DED1CACC for ; Fri, 6 Feb 2004 10:45:13 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 35093-07 for ; Fri, 6 Feb 2004 06:45:03 -0400 (AST) Received: from fuji.krosing.net (silmet.estpak.ee [194.126.97.78]) by svr1.postgresql.org (Postfix) with ESMTP id 2480BD1D269 for ; Fri, 6 Feb 2004 06:45:00 -0400 (AST) Received: from fuji.krosing.net (localhost.localdomain [127.0.0.1]) by fuji.krosing.net (8.12.8/8.12.8) with ESMTP id i16Aj0DJ002820; Fri, 6 Feb 2004 12:45:00 +0200 Received: (from hannu@localhost) by fuji.krosing.net (8.12.8/8.12.8/Submit) id i16AixuG002818; Fri, 6 Feb 2004 12:44:59 +0200 X-Authentication-Warning: fuji.krosing.net: hannu set sender to hannu@tm.ee using -f Subject: Re: 7.3 vs 7.4 performance From: Hannu Krosing To: Christopher Browne Cc: pgsql-performance@postgresql.org In-Reply-To: References: <1075958197.2438.330.camel@orthanc> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1076064299.2546.9.camel@fuji.krosing.net> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Fri, 06 Feb 2004 12:44:59 +0200 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/89 X-Sequence-Number: 5613 Christopher Browne kirjutas N, 05.02.2004 kell 07:32: > Oops! orion@trustcommerce.com (Orion Henry) was seen spray-painting on a wall: > > Oh... as a side note I'm happy to announce that the 2.6 Linux kernel > > has more than DOUBLED the speed of all my Postgres queries over the > > 2.4. =) > > I did some heavy-transaction-oriented tests recently on somewhat > heftier quad-Xeon hardware, and found little difference between 2.4 > and 2.6, and a small-but-quite-repeatable advantage with FreeBSD 4.9. > Now, I'm quite sure my load was rather different from yours, but I > find the claim of doubling of speed rather surprising. perhaps you were just IO-bound while he was not ? or starving on some locks ? ------------- Hannu