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 9582FD1B8E4 for ; Fri, 31 Oct 2003 16:42:37 +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 29012-02 for ; Fri, 31 Oct 2003 12:42:05 -0400 (AST) Received: from facnd.com (dslstatic-236-59.ideaone.net [64.21.236.59]) by svr1.postgresql.org (Postfix) with ESMTP id B991CD1B90B for ; Fri, 31 Oct 2003 12:42:04 -0400 (AST) Received: by facnd.com (Postfix on SuSE Linux 7.3 (i386), from userid 553) id 6D3D2FAB; Fri, 31 Oct 2003 10:42:11 -0600 (CST) Received: from rob (unknown [192.1.1.100]) by facnd.com (Postfix on SuSE Linux 7.3 (i386)) with ESMTP id 95075FA6; Fri, 31 Oct 2003 10:42:10 -0600 (CST) Reply-To: From: "Rob Sell" To: "'Bill Moran'" , Subject: Re: Pg+Linux swap use Date: Fri, 31 Oct 2003 10:42:06 -0600 Organization: Fargo Assembly Company Message-ID: <008a01c39fcd$eb8a0930$640101c0@rob> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.4510 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal In-Reply-To: <3FA285F5.6020408@potentialtech.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/797 X-Sequence-Number: 4545 For the record I am running on SuSE with a pretty much stock kernel. Not to sound na=EFve, but is turning of HT something done in the bios? Rob -----Original Message----- From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Bill Moran Sent: Friday, October 31, 2003 9:56 AM To: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Pg+Linux swap use Just for an additional viewpoint. I'm finishing up a project based on FreeBSD and PostgreSQL. The target server is a Dual 2.4G Intel machine. I have tested the application with hyperthreading enabled and disabled. To all appearances, enabling hyperthreading makes the box act like a quad, with the expected increase in processing capability - _for_this_application_. I have also heard the claims and seen the tests that show hyperthreading occasionally decreasing performance. I think in the end, you just have to test your particular application to see how it reacts. Rob Sell wrote: > Not being one to hijack threads, but I haven't heard of this performance hit > when using HT, I have what should all rights be a pretty fast server, dual > 2.4 Xeons with HT 205gb raid 5 array, 1 gig of memory. And it is only 50% as > fast as my old server which was a dual AMD MP 1400's with a 45gb raid 5 > array and 1gb of ram. I have read everything I could find on Pg performance > tweaked all the variables that were suggested and nothing. Which is why I > subscribed to this list, just been lurking so far but this caught my eye.= =20 >=20 > Rob >=20 > -----Original Message----- > From: pgsql-performance-owner@postgresql.org > [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Andrew Sullivan > Sent: Friday, October 31, 2003 8:36 AM > To: pgsql-performance@postgresql.org > Subject: Re: [PERFORM] Pg+Linux swap use >=20 > On Fri, Oct 31, 2003 at 12:03:59PM -0200, alexandre :: aldeia digital wrote: >=20 >>Scott, Jeff and Shridhar: >> >>1 GB RAM :) >> >>The stock kernels are not the same, HyperThreading enabled. 80 >=20 >=20 > Some people have reported that things actually slow down with HT > enabled. Have you tried turning it off? >=20 > A >=20 --=20 Bill Moran Potential Technologies http://www.potentialtech.com ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html