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 DCD84D1D528 for ; Fri, 6 Feb 2004 10:43:36 +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 33378-10 for ; Fri, 6 Feb 2004 06:43:27 -0400 (AST) Received: from fuji.krosing.net (silmet.estpak.ee [194.126.97.78]) by svr1.postgresql.org (Postfix) with ESMTP id 80F8FD1D18D for ; Fri, 6 Feb 2004 06:43:18 -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 i16AhGDJ002814; Fri, 6 Feb 2004 12:43:16 +0200 Received: (from hannu@localhost) by fuji.krosing.net (8.12.8/8.12.8/Submit) id i16AhEOu002812; Fri, 6 Feb 2004 12:43:14 +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: Orion Henry Cc: pgsql-performance@postgresql.org In-Reply-To: <1075958197.2438.330.camel@orthanc> References: <1075958197.2438.330.camel@orthanc> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1076064194.2546.6.camel@fuji.krosing.net> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Fri, 06 Feb 2004 12:43:14 +0200 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/88 X-Sequence-Number: 5612 Orion Henry kirjutas N, 05.02.2004 kell 07:16: > I've done some testing of 7.3.4 vs 7.4.1 and found 7.4.1 to be 20%-30% > slower than 7.3.4. Is this common knowledge or am I just unlucky with > my query/data selection? > > Things of note that might matter: the machine is a dual Opteron 1.4GHz > running Fedora Core 1 Test 1 for X86_64. The 7.3.4 was from the Fedora > distro and the 7.4.1 was the PGDG package. Are you sure that it is not the case that it is not tha case that 7.3.4 is 64 bit and the PGDG package is 32 ? > The database is 3.5 Gigs with 10 millions rows and the machine had 1 Gig or ram. > > 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. =) Is this on this same hardware ? ------------- Hannu