X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 12BCE3A3FFA for ; Tue, 23 Nov 2004 17:20:31 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 19843-01 for ; Tue, 23 Nov 2004 17:20:21 +0000 (GMT) Received: from jinx.internetstaff.com (unknown [63.214.174.241]) by svr1.postgresql.org (Postfix) with ESMTP id 556573A3FEF for ; Tue, 23 Nov 2004 17:20:20 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by jinx.internetstaff.com (Postfix) with ESMTP id E5AD14BC32F; Tue, 23 Nov 2004 10:20:18 -0700 (MST) Received: from jinx.internetstaff.com ([127.0.0.1]) by localhost (jinx [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 22049-01-63; Tue, 23 Nov 2004 10:20:08 -0700 (MST) Received: from blackbox.vcommerce.com (unknown [65.161.175.253]) by jinx.internetstaff.com (Postfix) with ESMTP id EBA6B4BC270; Tue, 23 Nov 2004 10:20:07 -0700 (MST) Subject: Re: Some quick Opteron 32-bit/64-bit results From: Cott Lang To: William Yu Cc: pgsql-performance@postgresql.org In-Reply-To: References: <87vfc78ug1.fsf@stark.xeocode.com> Content-Type: text/plain Date: Tue, 23 Nov 2004 10:20:07 -0700 Message-Id: <1101230407.5440.8.camel@localhost> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 (2.0.2-3) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at internetstaff.com X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/356 X-Sequence-Number: 9310 I ran quite a few file system benchmarks in RHAS x86-64 and FC2 x86-64 on a Sun V40z - I did see very consistent 50% improvements in bonnie++ moving from RHAS to FC2 with ext2/ext3 on SAN. On Sun, 2004-11-14 at 23:51 -0800, William Yu wrote: > Greg Stark wrote: > > William Yu writes: > > > > > >>Biggest speedup I've found yet is the backup process (PG_DUMP --> GZIP). 100% > >>faster in 64-bit mode. This drastic speed might be more the result of 64-bit > >>GZIP though as I've seen benchmarks in the past showing encryption/compression > >>running 2 or 3 times faster in 64-bit mode versus 32-bit. > > > > > > Isn't this a major kernel bump too? So a different scheduler, different IO > > scheduler, etc? > > > > I'm sure there's some speedup due to the kernel bump. I really didn't > have the patience to even burn the FC2 32-bit CDs much less install both > 32-bit & 64-bit FC2 in order to have a more accurate baseline comparison. > > However, that being said -- when you see huge speed increases like 50% > 100% for dump+gzip, it's doubtful the kernel/process scheduler/IO > scheduler could have made that drastic of a difference. Maybe somebody > else who has done a 2.4 -> 2.6 upgrade can give us a baseline to > subtract from my numbers. > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org