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.
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