From: Grzegorz Jaśkiewicz <gryzman@gmail.com>
To: S Arvind <arvindwill@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Running some query in low priority
Date: Thu, 5 Nov 2009 09:38:55 +0000
Message-ID: <2f4958ff0911050138n3f246b7ck6182cb702ac48e91@mail.gmail.com> (raw)
In-Reply-To: <abf9211d0911050136g48739f0ft53b63f96cddf706@mail.gmail.com>
References: <abf9211d0911050136g48739f0ft53b63f96cddf706@mail.gmail.com>
On Thu, Nov 5, 2009 at 9:36 AM, S Arvind <arvindwill@gmail.com> wrote:
> Hi Developers and Tuners,
> Is there any way to run some query in low priority and some query
> in higher priority in pg. The main reason for this is i need my main
> application(high priority) to be undisturbed by the sub application(low
> priority) which is running on same DB. Is there anyother good way to operate
> this?
>
other than manually re-nicing back end, no.
--
GJ
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-performance@postgresql.org
Cc: gryzman@gmail.com, arvindwill@gmail.com
Subject: Re: Running some query in low priority
In-Reply-To: <2f4958ff0911050138n3f246b7ck6182cb702ac48e91@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