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 E004CD1D9E6 for ; Sat, 7 Feb 2004 01:03:32 +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 71900-07 for ; Fri, 6 Feb 2004 21:03:34 -0400 (AST) Received: from front3.mail.megapathdsl.net (front3.mail.megapathdsl.net [66.80.60.32]) by svr1.postgresql.org (Postfix) with ESMTP id D1B4BD1D8AE for ; Fri, 6 Feb 2004 21:03:30 -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 125601327; Fri, 06 Feb 2004 17:03:33 -0800 Subject: Re: 7.3 vs 7.4 performance From: Orion Henry To: Hannu Krosing Cc: Christopher Browne , pgsql-performance@postgresql.org In-Reply-To: <1076064299.2546.9.camel@fuji.krosing.net> References: <1075958197.2438.330.camel@orthanc> <1076064299.2546.9.camel@fuji.krosing.net> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-FsiOBq/99i5gIC1gts9e" Organization: Message-Id: <1076115806.3377.122.camel@orthanc> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.2 (1.2.2-5) Date: 06 Feb 2004 17:03:26 -0800 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/105 X-Sequence-Number: 5629 --=-FsiOBq/99i5gIC1gts9e Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Fri, 2004-02-06 at 02:44, Hannu Krosing wrote: > 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. =3D) > >=20 > > 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. >=20 > perhaps you were just IO-bound while he was not ? >=20 > or starving on some locks ? The queries were across almost 4 gigs of data on a machine with 512 MB of r= am. I personally was assuming it was the anticipatory disk scheduler... but ala= s I=20 don't know why it affected me so much. --=-FsiOBq/99i5gIC1gts9e 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) iD8DBQBAJDle9IoQcq23xtARAtXAAJ9WQPOyJYDd+jVYeOzpAjewiRYtPACfZW7M IfuGj1u0dWda1MWGfhMyRwM= =dRe5 -----END PGP SIGNATURE----- --=-FsiOBq/99i5gIC1gts9e--