Background vacuum - Mailing list pgsql-performance

From Daniel Haensse
Subject Background vacuum
Date
Msg-id 4642A1B3.6030009@swissembedded.com
Whole thread Raw
Responses Re: Background vacuum
List pgsql-performance
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



pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Performance Woes
Next
From: Dan Harris
Date:
Subject: Re: Background vacuum