Chris Gamache wrote:
> What can be done to allow for smarter preemption? Could I do anything
at the OS
> level to throttle that particular postmaster's process? I'm running
> balanced config, but there's always room for improvement. Its that
> query that comes around once every so often that causes the problem.
You can basically renice the process that is performing the query.
See 'man nice' for details.
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2004-05-06 01:42:34|
|Subject: Re: Postmaster hogs CPU |
|Previous:||From: scott.marlowe||Date: 2004-05-05 21:25:16|
|Subject: Re: Postmaster hogs CPU|