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 0317FD1C9E1 for ; Thu, 5 Feb 2004 05:16:35 +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 11194-06 for ; Thu, 5 Feb 2004 01:16:39 -0400 (AST) Received: from front3.mail.megapathdsl.net (front3.mail.megapathdsl.net [66.80.60.32]) by svr1.postgresql.org (Postfix) with ESMTP id 14C6ED1C512 for ; Thu, 5 Feb 2004 01:16:33 -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 125079862 for pgsql-performance@postgresql.org; Wed, 04 Feb 2004 21:16:38 -0800 Subject: 7.3 vs 7.4 performance From: Orion Henry To: pgsql-performance@postgresql.org Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-YvIuE5J7VWwVd0qsLRg0" Organization: Message-Id: <1075958197.2438.330.camel@orthanc> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.2 (1.2.2-5) Date: 04 Feb 2004 21:16:37 -0800 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/67 X-Sequence-Number: 5591 --=-YvIuE5J7VWwVd0qsLRg0 Content-Type: text/plain Content-Transfer-Encoding: quoted-printable 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. 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. =3D) --=20 Orion Henry --=-YvIuE5J7VWwVd0qsLRg0 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) iD8DBQBAIdG19IoQcq23xtARAjvRAJ9Jho1WaVakSp3/cEINrBvEyM0+VwCeKSFf TDIT1jHr+z8XCXO7CC0crvQ= =glIm -----END PGP SIGNATURE----- --=-YvIuE5J7VWwVd0qsLRg0--