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: 40999045.2030502@bigfoot.com (view raw or flat)
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 
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

In response to

Responses

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-2014 The PostgreSQL Global Development Group