X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.192]) by svr1.postgresql.org (Postfix) with ESMTP id 9433CD1C50D for ; Tue, 22 Jul 2003 17:35:56 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr4.postgresql.org [64.117.224.192]) (amavisd-new, port 10024) with ESMTP id 80635-06 for ; Tue, 22 Jul 2003 17:35:55 +0000 (GMT) Received: from indygecko.com (h24-77-222-182.ok.shawcable.net [24.77.222.182]) by svr1.postgresql.org (Postfix) with ESMTP id A69D6D1C4C8 for ; Tue, 22 Jul 2003 14:35:54 -0300 (ADT) Received: from [192.168.10.10] ([::ffff:192.168.10.10]) by indygecko.com with esmtp; Tue, 22 Jul 2003 10:35:52 -0700 Subject: Re: Dual Xeon + HW RAID question From: Jord Tanner To: "SZUCS =?ISO-8859-1?Q?G=E1bor?=" Cc: pgsql-performance@postgresql.org In-Reply-To: <000701c35074$3800a2a0$0403a8c0@fejleszt4> References: <200307221626.h6MGQ1824547@candle.pha.pa.us> <000701c35074$3800a2a0$0403a8c0@fejleszt4> Content-Type: text/plain; charset=UTF-8 Organization: Message-Id: <1058895352.4339.32.camel@gecko> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.2 (1.2.2-5) Date: 22 Jul 2003 10:35:52 -0700 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/366 X-Sequence-Number: 2659 The Linux 2.6 kernel will have the ability to set CPU affinity for specific processes. There is a patch for the 2.4 kernel at http://www.kernel.org/pub/linux/kernel/people/rml/cpu-affinity RedHat 9 already has support for CPU affinity build in. The July 2003 issue of Linux Journal includes a little C program (on page 20) that gives you a shell level interface to the CPU affinity system calls, so you can dynamically assign processes to specific CPUs. I haven't tried it, but it looks very cool (my only SMP machine is in production, and I don't want to mess with it). If you try it out, please share your experiences with the list. Jord Tanner Independent Gecko Consultants On Tue, 2003-07-22 at 10:10, SZUCS Gábor wrote: > "by default" -- do you mean there is a way to tell Linux to favor the second > real cpu over the HT one? how? > > G. > ------------------------------- cut here ------------------------------- > ----- Original Message ----- > From: "Bruce Momjian" > Sent: Tuesday, July 22, 2003 6:26 PM > Subject: Re: [PERFORM] Dual Xeon + HW RAID question > > > > Right, I simplified it. The big deal is whether the OS favors the > > second real CPU over one of the virtual CPU's on the same die --- by > > default, it doesn't. Ever if it did work perfectly, you are talking > > about going from 1 to 1.4 or 2 to 2.8, which doesn't seem like much. > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend -- Jord Tanner