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 842DFD1B54E for ; Fri, 31 Oct 2003 15:55:13 +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 17027-10 for ; Fri, 31 Oct 2003 11:54:45 -0400 (AST) Received: from smtp.pspl.co.in (unknown [202.54.11.65]) by svr1.postgresql.org (Postfix) with ESMTP id 7266AD1B56A for ; Fri, 31 Oct 2003 11:54:40 -0400 (AST) Received: (from root@localhost) by smtp.pspl.co.in (8.12.9/8.12.9) id h9VFsvPw010700 for ; Fri, 31 Oct 2003 21:24:57 +0530 Received: from persistent.co.in (daithan.intranet.pspl.co.in [192.168.7.161]) (authenticated bits=0) by persistent.co.in (8.12.9/8.12.9) with ESMTP id h9VFsu04010687 for ; Fri, 31 Oct 2003 21:24:56 +0530 Message-ID: <3FA285C3.8050904@persistent.co.in> Date: Fri, 31 Oct 2003 21:24:43 +0530 From: Shridhar Daithankar Organization: Persistent Systems Pvt. Ltd. User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5) Gecko/20031013 Thunderbird/0.3 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Pg+Linux swap use References: <20031031143624.GB5394@libertyrms.info> <007c01c39fc4$0844f850$640101c0@rob> <20031031103902.0443c135.threshar@torgo.978.org> In-Reply-To: <20031031103902.0443c135.threshar@torgo.978.org> 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/792 X-Sequence-Number: 4540 Jeff wrote: > On Fri, 31 Oct 2003 09:31:19 -0600 > "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. >> >>Rob > There's benchmarks around that show in _some_ cases HT is not all it is > cracked up to be, somtimes running slower. To use HT effectively on needs. 1. A kernel that understands HT. 2. A task scheduler that understands HT 3. A CPU intensive load. So if you are running a stock RedHat and production postgresql database, turn it off. It won't hurt certainly(Almost certainly) > I'm guessing RH is running some useless stuff in the BG.. or maybe he's > running a retarded kernel... or.. maybe.. just.. maybe.. little elves > are doing it. Too much..:-) I guess Alexandre can tune bdflush to be little less agressive. Comparing bdflush values on two machines might turn up something. His idea of compiling kernel is also good one. He can also try tuning some values in /proc/sys/vm but I don't find any documentation offhand. I usually run slackware and a handcompiled 2.6-test4. None of them use any swap unless true memory starts falling low. This touch-swap-even-if-oodles-of-ram-is-free is something I have't experienced on my desktop for quite a while. Shridhar