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 0A716D1B4E1 for ; Fri, 31 Oct 2003 15:32:04 +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 10308-09 for ; Fri, 31 Oct 2003 11:31:36 -0400 (AST) Received: from facnd.com (dslstatic-236-59.ideaone.net [64.21.236.59]) by svr1.postgresql.org (Postfix) with ESMTP id 75CBFD1B508 for ; Fri, 31 Oct 2003 11:31:28 -0400 (AST) Received: by facnd.com (Postfix on SuSE Linux 7.3 (i386), from userid 553) id E35D9FAB; Fri, 31 Oct 2003 09:31:24 -0600 (CST) Received: from rob (unknown [192.1.1.100]) by facnd.com (Postfix on SuSE Linux 7.3 (i386)) with ESMTP id 42F93FA6; Fri, 31 Oct 2003 09:31:24 -0600 (CST) Reply-To: From: "Rob Sell" To: "'Andrew Sullivan'" , Subject: Re: Pg+Linux swap use Date: Fri, 31 Oct 2003 09:31:19 -0600 Organization: Fargo Assembly Company Message-ID: <007c01c39fc4$0844f850$640101c0@rob> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" 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: <20031031143624.GB5394@libertyrms.info> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/790 X-Sequence-Number: 4538 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 Rob -----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 On Fri, Oct 31, 2003 at 12:03:59PM -0200, alexandre :: aldeia digital wrote: > Scott, Jeff and Shridhar: >=20 > 1 GB RAM :) >=20 > The stock kernels are not the same, HyperThreading enabled. 80 Some people have reported that things actually slow down with HT enabled. Have you tried turning it off? A --=20 ---- Andrew Sullivan 204-4141 Yonge Street Afilias Canada Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend