Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id BB0742E0129 for ; Sun, 16 Mar 2008 15:11:59 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 79900-06 for ; Sun, 16 Mar 2008 15:11:54 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 9D2DB2E0111 for ; Sun, 16 Mar 2008 15:11:52 -0300 (ADT) Received: (qmail invoked by alias); 16 Mar 2008 18:11:51 -0000 Received: from xdsl-87-79-136-129.netcologne.de (EHLO colt.pezone.net) [87.79.136.129] by mail.gmx.net (mp046) with SMTP; 16 Mar 2008 19:11:51 +0100 X-Authenticated: #495269 X-Provags-ID: V01U2FsdGVkX1/3Wf0wMrn31fexDu49c/ZW0oY5QvQmXIQ+HEsMfm 5tN0lASLjMdEur From: Peter Eisentraut To: pgsql-performance@postgresql.org Subject: Re: best way to run maintenance script Date: Sun, 16 Mar 2008 19:11:48 +0100 User-Agent: KMail/1.9.7 Cc: Vinubalaji Gopal References: <1205542821.12661.16.camel@vinu-ubuntu.abaca> In-Reply-To: <1205542821.12661.16.camel@vinu-ubuntu.abaca> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200803161911.49571.peter_e@gmx.net> X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/334 X-Sequence-Number: 29288 Vinubalaji Gopal wrote: > I tried using the nice command (Linux system) on the maintenance script > - it did not have any effect - guess it does not change the niceness of > the postgresql vacuum process. You are probably looking for the command ionice. nice only affects the CPU priority, and that is usually not the primary problem for vacuum. (And yes, you need to nice the server process, not the client script.)