On Fri, 24 Oct 2003, Vivek Khera wrote:
> >>>>> "AL" == Allen Landsidel <[EMAIL PROTECTED]> writes:
>
> AL> Well I had the vacuums running every 15 minutes for a while.. via a
> AL> simple cron script I wrote just to make sure no more than one vacuum
> AL> ran at once, and to 'nice' the job.. but performance on the db does
>
> "nice"-ing the client does nothing for the backend server that does
> the actual work. You need to track down the PID of the backend server
> running the vacuum and renice *it* to get any effect.
Advertising
Note that Tom has mentioned problems with possible deadlocks when nicing
individual backends before, so proceed with caution here.
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
