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 B585BD1CCCC for ; Sat, 7 Feb 2004 01:02:17 +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 75451-03 for ; Fri, 6 Feb 2004 21:02:19 -0400 (AST) Received: from front3.mail.megapathdsl.net (front3.mail.megapathdsl.net [66.80.60.32]) by svr1.postgresql.org (Postfix) with ESMTP id CCBECD1CA67 for ; Fri, 6 Feb 2004 21:02:14 -0400 (AST) Received: from [64.32.131.193] (HELO [192.168.1.11]) by front3.mail.megapathdsl.net (CommuniGate Pro SMTP 4.1.3) with ESMTP id 125601182; Fri, 06 Feb 2004 17:02:16 -0800 Subject: Re: 7.3 vs 7.4 performance From: Orion Henry To: Hannu Krosing Cc: pgsql-performance@postgresql.org In-Reply-To: <1076064194.2546.6.camel@fuji.krosing.net> References: <1075958197.2438.330.camel@orthanc> <1076064194.2546.6.camel@fuji.krosing.net> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-509eXqC/54em5njBok9b" Organization: Message-Id: <1076115730.3377.119.camel@orthanc> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.2 (1.2.2-5) Date: 06 Feb 2004 17:02:10 -0800 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/104 X-Sequence-Number: 5628 --=-509eXqC/54em5njBok9b Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Fri, 2004-02-06 at 02:43, Hannu Krosing wrote: > 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? > >=20 > > 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. >=20 > 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 ? Yes sure... I don't know if they were compiled with differing optimizations or compilers though... > > The database is 3.5 Gigs with 10 millions rows and the machine had 1 Gi= g or ram. > >=20 > > 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. = =3D) >=20 > Is this on this same hardware ? No. I havent gotten the 2.6 kernel working on the Opteron yet. The 2x spe= edup=20 was on a dual Athlon 2GHz. --=-509eXqC/54em5njBok9b Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQBAJDkS9IoQcq23xtARAqBJAJ9EQYm1SVy+FC96vq+B2MdRa0UswwCeKjT+ 2wIphftBjTCOr5JDXe/1JrA= =2Rq4 -----END PGP SIGNATURE----- --=-509eXqC/54em5njBok9b--