>>>>> "AL" == Allen Landsidel <[EMAIL PROTECTED]> writes:
Advertising
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. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
