From: Andreas Kretschmer <akretschmer@spamfence.net>
To: pgsql-general@postgresql.org
Subject: Re: [ADMIN] Priorities for users or queries?
Date: Sun, 11 Feb 2007 09:47:16 +0100
Message-ID: <20070211084716.GB6652@KanotixBox> (raw)
In-Reply-To: <376dd1950702110031i40d41133n85c6010d3f81d903@mail.gmail.com>
References: <45CE69B5.40204@araisoft.com>
<376dd1950702110031i40d41133n85c6010d3f81d903@mail.gmail.com>
Edwin Eyan Moragas <haaktu@gmail.com> schrieb:
> On 2/11/07, Benjamin Arai <benjamin@araisoft.com> wrote:
> >Hi,
> >Is there a way to give priorities to queries or users? Something
> >similar to NICE in Linux. My goal is to give the updating (backend)
> >application a very low priority and give the web application a high
> >priority to avoid disturbing the user experience.
> >Thanks in advance!
>
> with all due respect to Josh who has replied to this question already.
Just an idea:
You can retrieve the PID and the username of running querys in
pg_stat_activity. Perhaps, with this knowledge and an untrusted language
you can run system-commands such renice to change the priority of
running postmaster-processes.
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknow)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
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 using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: akretschmer@spamfence.net, pgsql-general@postgresql.org
Subject: Re: [ADMIN] Priorities for users or queries?
In-Reply-To: <20070211084716.GB6652@KanotixBox>
* 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