Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id B2DCE632727
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu,  5 Nov 2009 05:39:08 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 68696-03
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu,  5 Nov 2009 09:38:53 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-bw0-f213.google.com (mail-bw0-f213.google.com
	[209.85.218.213])
	by mail.postgresql.org (Postfix) with ESMTP id 8BC026325E5
	for <pgsql-performance@postgresql.org>;
	Thu,  5 Nov 2009 05:38:57 -0400 (AST)
Received: by bwz5 with SMTP id 5so616219bwz.3
	for <pgsql-performance@postgresql.org>;
	Thu, 05 Nov 2009 01:38:55 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:message-id:subject:from:to:cc:content-type;
	bh=0inmTyIDdXHk0Eu4tCU4HxZgdFAteXRmIH12UayIs0E=;
	b=f/4nzbmhvwF5iWAvmJyFMh/qvTOtHrH2CEzrcfXVC0V8fe9hiO4EOVbY8L/y2dwRYn
	Wvrymdxjh+amzoKsvUDAWVyms+E5+U0jBdZ5JhfheVxcMKaEonroIKXbSrB2G573xyU1
	6qO5Oh0wr8jnbBkPSZKGqRDQMv7msDyfx4/Q8=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=hHyv0kC+3HWViTo6zsmscLIU3L1R8dPA0Ngtn6h3yGnur8sBNGM/URqgrfxAiXsiSP
	RIsg7JfSPMrcDi9R11sXMxFc4ZT//LIzG4BTzTXyxka3RGXlmxIM9+Js46+ekmEvphsY
	IDuLQ+D8Kci1PD03YLrqJqpOVvO+OGtO7ZfLs=
MIME-Version: 1.0
Received: by 10.204.153.24 with SMTP id i24mr1222603bkw.114.1257413935182;
	Thu, 05 Nov 2009 01:38:55 -0800 (PST)
In-Reply-To: <abf9211d0911050136g48739f0ft53b63f96cddf706@mail.gmail.com>
References: <abf9211d0911050136g48739f0ft53b63f96cddf706@mail.gmail.com>
Date: Thu, 5 Nov 2009 09:38:55 +0000
Message-ID: <2f4958ff0911050138n3f246b7ck6182cb702ac48e91@mail.gmail.com>
Subject: Re: Running some query in low priority
From: =?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= <gryzman@gmail.com>
To: S Arvind <arvindwill@gmail.com>
Cc: pgsql-performance@postgresql.org
Content-Type: multipart/alternative; boundary=0015175dd9cef1336d04779c7ee2
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.374 tagged_above=-10 required=5 tests=AWL=0.224,
	BAYES_00=-2.599, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200911/62
X-Sequence-Number: 36230

--0015175dd9cef1336d04779c7ee2
Content-Type: text/plain; charset=UTF-8

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

--0015175dd9cef1336d04779c7ee2
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<br><br><div class=3D"gmail_quote">On Thu, Nov 5, 2009 at 9:36 AM, S Arvind=
 <span dir=3D"ltr">&lt;<a href=3D"mailto:arvindwill@gmail.com">arvindwill@g=
mail.com</a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quote" style=
=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; p=
adding-left: 1ex;">
Hi Developers and Tuners,<br>=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0 Is there any way to run some query in low priority and some query in hi=
gher 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) whic=
h is running on same DB. Is there anyother good way to operate this?<br>


</blockquote><div><br>other than manually re-nicing back end, no.<br>=C2=A0=
<br></div></div><br><br clear=3D"all"><br>-- <br>GJ<br>

--0015175dd9cef1336d04779c7ee2--