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

Re: Postmaster hogs CPU

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: Chris Gamache <cgg007(at)yahoo(dot)com>
Subject: Re: Postmaster hogs CPU
Date: 2004-05-06 01:09:25
Message-ID: (view raw or whole thread)
Lists: 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 
 > 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.

Gaetano Mendola

In response to


pgsql-admin by date

Next:From: Tom LaneDate: 2004-05-06 01:42:34
Subject: Re: Postmaster hogs CPU
Previous:From: scott.marloweDate: 2004-05-05 21:25:16
Subject: Re: Postmaster hogs CPU

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