Re: Running some query in low priority

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: S Arvind <arvindwill(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Running some query in low priority
Date: 2009-11-05 09:38:55
Message-ID: 2f4958ff0911050138n3f246b7ck6182cb702ac48e91@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Nov 5, 2009 at 9:36 AM, S Arvind <arvindwill(at)gmail(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Stark 2009-11-05 11:32:22 Re: Running some query in low priority
Previous Message S Arvind 2009-11-05 09:36:31 Running some query in low priority