Re: Postmaster hogs CPU - Mailing list pgsql-admin

From Gaetano Mendola
Subject Re: Postmaster hogs CPU
Date
Msg-id 40999045.2030502@bigfoot.com
Whole thread Raw
In response to Postmaster hogs CPU  (Chris Gamache <cgg007@yahoo.com>)
Responses Re: Postmaster hogs CPU
List pgsql-admin
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

pgsql-admin by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Postmaster hogs CPU
Next
From: Tom Lane
Date:
Subject: Re: Postmaster hogs CPU