From: Aaron Bono <postgresql@aranya.com>
To: Thomas Pundt <thomas.pundt@rp-online.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: Controlling CPU Usage in PostgreSQL
Date: Tue, 1 Aug 2006 13:59:00 -0500
Message-ID: <bf05e51c0608011159h74ac3a44wdb98b8ab32803275@mail.gmail.com> (raw)
In-Reply-To: <200607311101.36629.mlists@rp-online.de>
References: <bf05e51c0607310106w415fe34ep4b5046984cd11341@mail.gmail.com>
<200607311101.36629.mlists@rp-online.de>
On 7/31/06, Thomas Pundt <mlists@rp-online.de> wrote:
>
> On Monday 31 July 2006 10:06, Aaron Bono wrote:
> | Is there a way I can tell PostgreSQL to give session a low priority so
> even
> | if it does take the full CPU, it only does so if it would otherwise be
> | idle?
>
> the "nice" command might do what you want...
OK, so I tried:
su - postgres -c "nice -n 19 psql my_db"
The problem is, the psql command has a nice value of 19 but the PostgreSQL
server process that psql has connected to is running with a nice value of
0. My assumption is that, if I then run my functions, psql will get low
priority but it is the server process that is running with normal priority
that will still use up all the CPU.
Bottom line, I am skeptical if this will really achieve my goal - to have
the functions run with low priority.
Is there a way to tell PostgreSQL to change the nice value of a particular
connection? I guess I could use renice but that means a lot of shell
scripting to determine what PID to change - I am not a shell script expert
and would rather not pursue that option.
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
==================================================================
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: postgresql@aranya.com, thomas.pundt@rp-online.de
Subject: Re: Controlling CPU Usage in PostgreSQL
In-Reply-To: <bf05e51c0608011159h74ac3a44wdb98b8ab32803275@mail.gmail.com>
References: <bf05e51c0607310106w415fe34ep4b5046984cd11341@mail.gmail.com> <200607311101.36629.mlists@rp-online.de> <bf05e51c0608011159h74ac3a44wdb98b8ab32803275@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox