From: Daniel Haensse <daniel.haensse@swissembedded.com>
To: pgsql-performance@postgresql.org
Subject: Background vacuum
Date: Thu, 10 May 2007 06:38:11 +0200
Message-ID: <4642A1B3.6030009@swissembedded.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: daniel.haensse@swissembedded.com
Subject: Re: Background vacuum
In-Reply-To: <4642A1B3.6030009@swissembedded.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox