Skip site navigation (1) Skip section navigation (2)

Re: My own performance/tuning q&a

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Vivek Khera <khera(at)kcilink(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: My own performance/tuning q&a
Date: 2003-10-24 16:32:52
Message-ID: Pine.LNX.4.33.0310241032270.24949-100000@css120.ihs.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Fri, 24 Oct 2003, Vivek Khera wrote:

> >>>>> "AL" == Allen Landsidel <all(at)biosys(dot)net> 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.


In response to

Responses

pgsql-performance by date

Next:From: Vivek KheraDate: 2003-10-24 16:47:19
Subject: Re: My own performance/tuning q&a
Previous:From: Vivek KheraDate: 2003-10-24 15:50:47
Subject: Re: My own performance/tuning q&a

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group