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
(IMO) a
> balanced config, but there's always room for improvement. Its that
oddball
> 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.
Regards
Gaetano Mendola