Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 2E1199F9F47 for ; Thu, 14 Dec 2006 19:59:54 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 53262-01 for ; Thu, 14 Dec 2006 19:59:45 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from smtp3.clear.net.nz (smtp3.clear.net.nz [203.97.33.64]) by postgresql.org (Postfix) with ESMTP id B909C9FA0B7 for ; Thu, 14 Dec 2006 19:59:49 -0400 (AST) Received: from [192.168.1.11] (121-72-71-26.dsl.telstraclear.net [121.72.71.26]) by smtp3.clear.net.nz (CLEAR Net Mail) with ESMTP id <0JAA00GE0FZNCC40@smtp3.clear.net.nz> for pgsql-performance@postgresql.org; Fri, 15 Dec 2006 12:59:48 +1300 (NZDT) Date: Fri, 15 Dec 2006 12:59:40 +1300 From: Mark Kirkwood Subject: Re: EXPLAIN ANALYZE on 8.2 In-reply-to: To: Kelly Burkhart Cc: Tom Lane , Evgeny Gridasov , pgsql-performance@postgresql.org Message-id: <4581E56C.5050209@paradise.net.nz> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7bit References: <20061214163230.d46f0138.eugrid@fpm.kubsu.ru> <21146.1166112702@sss.pgh.pa.us> <20061214192920.c75385d6.eugrid@fpm.kubsu.ru> <21516.1166114475@sss.pgh.pa.us> User-Agent: Thunderbird 1.5.0.8 (X11/20061129) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/391 X-Sequence-Number: 22447 Kelly Burkhart wrote: > > I hope this isn't a "crummy mainboard" but I can't seem to affect > things by changing clock source (kernel 2.6.16 SLES10). I tried > kernel command option clock=XXX where XXX in > (cyclone,hpet,pmtmr,tsc,pit), no option was significantly better than > the default. > > Anyone know how this might be improved (short of replacing hardware)? > Updating the BIOS might be worth investigating, and then bugging your Linux distro mailing list/support etc for more help. (What sort of motherboard is it?) Cheers Mark