X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id EFEAF9FB356 for ; Mon, 31 Jul 2006 06:21:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 66999-05 for ; Mon, 31 Jul 2006 06:20:44 -0300 (ADT) X-Greylist: delayed 00:18:03.564195 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 8FCA29FB35B for ; Mon, 31 Jul 2006 06:20:07 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mail.rp-online.de (mail.rp-online.de [149.221.1.199]) by svr4.postgresql.org (Postfix) with ESMTP id BBAA95AFB20 for ; Mon, 31 Jul 2006 09:01:52 +0000 (GMT) Received: from idefix.d.rp-online.de (idefix.d.rp-online.de [149.221.100.194]) by mail.rp-online.de (Postfix) with ESMTP id E302C2E83F; Mon, 31 Jul 2006 11:01:34 +0200 (CEST) From: Thomas Pundt Reply-To: Thomas Pundt Organization: RP Online Verlagsgesellschaft mbH To: pgsql-admin@postgresql.org, "Aaron Bono" Subject: Re: Controlling CPU Usage in PostgreSQL Date: Mon, 31 Jul 2006 11:01:36 +0200 User-Agent: KMail/1.9.1 References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200607311101.36629.mlists@rp-online.de> X-Anti-Virus: Kaspersky Anti-Virus for MailServers 5.5.3/RELEASE, bases: 30072006 #198333, status: clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.816 tagged_above=0 required=5 tests=SPF_HELO_SOFTFAIL, SPF_SOFTFAIL X-Spam-Level: *** X-Archive-Number: 200607/292 X-Sequence-Number: 22538 On Monday 31 July 2006 10:06, Aaron Bono wrote: | Is there a way I can tell PostgreSQL to give session a low priority so even | if it does take the full CPU, it only does so if it would otherwise be | idle? the "nice" command might do what you want... Ciao, Thomas -- Thomas Pundt ---- http://rp-online.de/ ----