From rjessil@yahoo.com Thu Aug 9 02:33:02 2007 Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id B5A889FB7D4 for ; Wed, 8 Aug 2007 23:33:02 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 56166-02 for ; Wed, 8 Aug 2007 23:32:53 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from web56409.mail.re3.yahoo.com (web56409.mail.re3.yahoo.com [216.252.111.88]) by postgresql.org (Postfix) with SMTP id C50779FB72F for ; Wed, 8 Aug 2007 23:32:53 -0300 (ADT) Received: (qmail 96866 invoked by uid 60001); 9 Aug 2007 02:32:52 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=4hY0Za9xEnRWK2Gnn5KcX7xj7Aq2Qw4lpDCqqMsEGUexfoRW6RVrGgszxk9h+wJ8lYUplAQglKjpzQldcZzBduk36btfZ1Q4p/6eLoeznAF9D2ilDWaLTCgHNVALH09P1BEzJkpLWNZ5YPI0t5nboV1S+lWudW3VefVQBlvauZQ=; X-YMail-OSG: fxmo1BYVM1l6bqhQT0Ny_rSPiiTn4LZROMGi3h9QP.piyX8kwpEhsjXYHYYAGCWWdB31dzvMBC__QenvdytqlC1hzOn7k4vPUuUg Received: from [68.0.34.26] by web56409.mail.re3.yahoo.com via HTTP; Wed, 08 Aug 2007 19:32:52 PDT Date: Wed, 8 Aug 2007 19:32:52 -0700 (PDT) From: Jessica Richard Subject: cpu usage on the linux machine To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-174730707-1186626772=:96751" Content-Transfer-Encoding: 8bit Message-ID: <335758.96751.qm@web56409.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/93 X-Sequence-Number: 26424 --0-174730707-1186626772=:96751 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit If the linux box has 8 CPU's, is there a way to configure for Postgres to user 6 of them? how? Thanks! --------------------------------- Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel and lay it on us. --0-174730707-1186626772=:96751 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit If the linux box has 8 CPU's, is there a way to configure for Postgres to user 6 of them? how? Thanks!


Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel and lay it on us. --0-174730707-1186626772=:96751-- From jd@commandprompt.com Thu Aug 9 02:38:27 2007 Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id E2FAE9FC092 for ; Wed, 8 Aug 2007 23:38:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 24606-10 for ; Wed, 8 Aug 2007 23:38:18 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id 73FB69FB78F for ; Wed, 8 Aug 2007 23:38:24 -0300 (ADT) Received: from [192.168.1.50] (or-67-76-146-141.sta.embarqhsd.net [67.76.146.141]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l792cRbW001212; Wed, 8 Aug 2007 19:38:27 -0700 Message-ID: <46BA7E9E.3060800@commandprompt.com> Date: Wed, 08 Aug 2007 19:40:30 -0700 From: "Joshua D. Drake" User-Agent: Thunderbird 1.5.0.12 (X11/20070604) MIME-Version: 1.0 To: Jessica Richard CC: pgsql-admin@postgresql.org Subject: Re: cpu usage on the linux machine References: <335758.96751.qm@web56409.mail.re3.yahoo.com> In-Reply-To: <335758.96751.qm@web56409.mail.re3.yahoo.com> X-Enigmail-Version: 0.94.2.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV 0.91.1/3892/Wed Aug 8 03:05:19 2007 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Wed, 08 Aug 2007 19:38:28 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/95 X-Sequence-Number: 26426 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Jessica Richard wrote: > If the linux box has 8 CPU's, is there a way to configure for Postgres to user 6 of them? how? Thanks! No. Joshua D. Drake > > > --------------------------------- > Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel and lay it on us. - -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGun6eATb/zqfZUUQRAg3wAJ9iiDQY809thJ8S71U8ev17OlwleQCeJJGU qZ7l7Lj9b3dnww9fml9uYoU= =8y+7 -----END PGP SIGNATURE----- From scott.marlowe@gmail.com Thu Aug 9 02:49:36 2007 Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 2F5E29FBFAB for ; Wed, 8 Aug 2007 23:49:36 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 22419-06 for ; Wed, 8 Aug 2007 23:49:22 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.187]) by postgresql.org (Postfix) with ESMTP id 3B9169FB80B for ; Wed, 8 Aug 2007 23:49:31 -0300 (ADT) Received: by rv-out-0910.google.com with SMTP id f1so260450rvb for ; Wed, 08 Aug 2007 19:49:29 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=gQo/4hZUQycBM/ZVbDvM2nUFRE5+xkm8PP2DOqezHoBdE4i+jy9mjAywl1jU49RAyLiABQkD+WMyrVHumRkg9T5cgd8NrvwAQxjGfu06iXZW8EWkvHU8NyZJ2DY1qq89NDwTKjC7eiLW9oRXjWJj8GOMlPI8Bz6umKYvT8A5TN4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=SiPDn2xUBV6GNsQMl0rMTvHK9Fdh4IYJwfm2MB5An9zzfvM3pYkhySfP4GAxPNPe7BJFrfsHkTqLzAErM5pV0kKyrVGFY1sMkgzpUxf8SnSl34/sZiXJN5GtWgxyahpHeHpnCeokZyO4Hk7bVLvZV0ZfC3BPnSCQk7t4lyYkclE= Received: by 10.140.186.18 with SMTP id j18mr740022rvf.1186627769541; Wed, 08 Aug 2007 19:49:29 -0700 (PDT) Received: by 10.141.98.12 with HTTP; Wed, 8 Aug 2007 19:49:29 -0700 (PDT) Message-ID: Date: Wed, 8 Aug 2007 21:49:29 -0500 From: "Scott Marlowe" To: "Jessica Richard" Subject: Re: cpu usage on the linux machine Cc: pgsql-admin@postgresql.org In-Reply-To: <335758.96751.qm@web56409.mail.re3.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <335758.96751.qm@web56409.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/97 X-Sequence-Number: 26428 On 8/8/07, Jessica Richard wrote: > If the linux box has 8 CPU's, is there a way to configure for Postgres to > user 6 of them? how? Thanks! There are some kernel hacks for CPU affinity. they might be able to do a bit of that. Other than that, limited postgresql to only 6 non-superuser connections might do the trick. From zawadaa@gmail.com Tue Aug 21 21:41:31 2007 Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 7B7A39F9545 for ; Tue, 21 Aug 2007 18:41:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 13769-06 for ; Tue, 21 Aug 2007 18:41:22 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.188]) by postgresql.org (Postfix) with ESMTP id 3B8E39F9543 for ; Tue, 21 Aug 2007 18:41:27 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id f5so1179762nfh for ; Tue, 21 Aug 2007 14:41:25 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:subject:references:in-reply-to:content-type:content-transfer-encoding; b=LSfV5zBGtuN+wtu5omRxYLzmtULMmoBzHXDKT6A9JFvrOkfrtb4btsu+RN+pQjAATaXjpO+qe5ge4Txn78xNdgnCzvUau2TqmXYHw7mF1d8/tVBhOsMCQc64Lscf5zxqgDTZrkPdx55Whkk6OyDyqFXBo0Hw1nQvl9uJuaCWRpM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:to:subject:references:in-reply-to:content-type:content-transfer-encoding; b=bZTzpj896COONAmz31n1Sz8KLpvzWOEsFc4qtuWwcITF+pN1fPExuZqj95tf30zoJpDoWogRXHnKGyhTXPRej8lNh1kOZ8ZPjBvfnCuVd0J9sOPPZ37ruXXqqeWjRNTFft1sfAM2JR/FsjYTpYNFENoxQ+VTUfrO/EXn97zLabU= Received: by 10.86.49.13 with SMTP id w13mr5748678fgw.1187732485316; Tue, 21 Aug 2007 14:41:25 -0700 (PDT) Received: from ?192.168.10.169? ( [83.11.62.53]) by mx.google.com with ESMTPS id p9sm12741849fkb.2007.08.21.14.41.17 (version=TLSv1/SSLv3 cipher=RC4-MD5); Tue, 21 Aug 2007 14:41:18 -0700 (PDT) Message-ID: <46CB5BF9.4000403@gmail.com> Date: Tue, 21 Aug 2007 23:41:13 +0200 From: Andrzej Zawadzki User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.6) Gecko/20070820 PLD/2.0 (Ac) SeaMonkey/1.1.4 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: cpu usage on the linux machine References: <335758.96751.qm@web56409.mail.re3.yahoo.com> In-Reply-To: <335758.96751.qm@web56409.mail.re3.yahoo.com> Content-Type: text/plain; charset=ISO-8859-2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/263 X-Sequence-Number: 26594 Jessica Richard wrote: > If the linux box has 8 CPU's, is there a way to configure for Postgres > to user 6 of them? how? Thanks! Try that: http://www.bullopensource.org/cpuset/ -- Andrzej Zawadzki PLD