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.