Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id D17F09FB3AF for ; Thu, 10 May 2007 01:58:30 -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 48218-01 for ; Thu, 10 May 2007 01:58:18 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 1E7BD9FB4CF for ; Thu, 10 May 2007 01:58:25 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from abalone.webinterface.ch (unknown [213.144.148.114]) by svr4.postgresql.org (Postfix) with ESMTP id C336A5AF034 for ; Thu, 10 May 2007 04:38:13 +0000 (GMT) Received: from 80-218-196-137.dclient.hispeed.ch ([80.218.196.137] helo=[192.168.0.245]) by abalone.webinterface.ch with esmtpa (Exim 4.44) id 1Hm0Di-0000cg-6v for pgsql-performance@postgresql.org; Thu, 10 May 2007 06:25:38 +0200 Message-ID: <4642A1B3.6030009@swissembedded.com> Date: Thu, 10 May 2007 06:38:11 +0200 From: Daniel Haensse Reply-To: daniel.haensse@swissembedded.com Organization: swissEmbedded GmbH User-Agent: Thunderbird 1.5.0.9 (X11/20060911) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Background vacuum Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.386 tagged_above=0 required=5 tests=AWL=0.250, BAYES_50=0.001, FORGED_RCVD_HELO=0.135 X-Spam-Level: X-Archive-Number: 200705/220 X-Sequence-Number: 24610 Dear list, I'm running postgres on a tomcat server. The vacuum is run every hour (cronjob) which leads to a performance drop of the tomcat applications. I played around with renice command and I think it is possible to reduce this effect which a renice. The problem is how can I figure out the PID of the postmaster performing the vacuum(automated)? Has anybody a nice solution to change process priority? A shell script, maybe even for java? best regards Dani