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 091A4D1B8A0 for ; Fri, 31 Oct 2003 16:56:22 +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 29780-02 for ; Fri, 31 Oct 2003 12:55:51 -0400 (AST) Received: from mta3.adelphia.net (mta3.adelphia.net [68.168.78.181]) by svr1.postgresql.org (Postfix) with ESMTP id E01D7D1B54F for ; Fri, 31 Oct 2003 12:55:50 -0400 (AST) Received: from potentialtech.com ([68.68.113.33]) by mta3.adelphia.net (InterMail vM.5.01.06.05 201-253-122-130-105-20030824) with ESMTP id <20031031165553.OLWA16926.mta3.adelphia.net@potentialtech.com>; Fri, 31 Oct 2003 11:55:53 -0500 Message-ID: <3FA29415.7080901@potentialtech.com> Date: Fri, 31 Oct 2003 11:55:49 -0500 From: Bill Moran User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20031005 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Greg Stark Cc: pgsql-performance@postgresql.org Subject: Re: Pg+Linux swap use References: <007c01c39fc4$0844f850$640101c0@rob> <3FA285F5.6020408@potentialtech.com> <87ekwtbbxi.fsf@stark.dyndns.tv> In-Reply-To: <87ekwtbbxi.fsf@stark.dyndns.tv> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/798 X-Sequence-Number: 4546 Greg Stark wrote: > Bill Moran writes: > >>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. > > My understanding is that the case where HT hurts is precisely your case. When > you have two real processors with HT the kernel will sometimes schedule two > jobs on the two virtual processors on the same real processor leaving the two > virtual processors on the other real processor idle. Yup, that's why I tested it. While more testing is probably in order, I could find no disadvantages to running with HTT enabled. And when I ran many background jobs (which is likely to happen during batch processing on this sytem) the system seemed to perform as if it really had 4 processors. Perhaps this is an indication of the quality of the FreeBSD scheduler (maybe it's HTT aware and makes decisions accordingly?), but I'm not involved enough in that level of development to do any more than speculate. Again, this is pure speculation ... can anyone with a more technical insight comment on whether my guess is correct, or whether I'm not testing enough? -- Bill Moran Potential Technologies http://www.potentialtech.com