Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 7DCB46327F0 for ; Thu, 5 Nov 2009 05:37:00 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 13000-02 for ; Thu, 5 Nov 2009 09:36:52 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-px0-f187.google.com (mail-px0-f187.google.com [209.85.216.187]) by mail.postgresql.org (Postfix) with ESMTP id 982536325E5 for ; Thu, 5 Nov 2009 05:36:52 -0400 (AST) Received: by pxi17 with SMTP id 17so3152752pxi.20 for ; Thu, 05 Nov 2009 01:36:51 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:from:date:message-id :subject:to:content-type; bh=FMHTwxxIyN4DKWlB3nLAFTB0hkTsBdhoBqiilRGREHE=; b=AGj3Oo0wlY0ygfolAnoL11Aqo2ddvl/QutDGJcCgbAGV5RTxp2x8ZjOBtbN/ne8YZY VG7bL+46WjNkWom9KEkd43/8qzw2dTMJrrOY6qM8chrgBgn4rMlNKRqt2dpCEYjCEVtg Z2ztLFonpHl6EfP3wpeaTz7J6gULBpLlEC2tM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:from:date:message-id:subject:to:content-type; b=H8ML6vkP1y4c/MZu9NUi0xsBZgmTzv0zyIFqzsjbKoeu0GgO/Pbj7kTYHYOtvLZlby 0UyOERuixYvXP0+AMEM/91T4/w3lHyYljaMxHMYiZqII5lASkW44z0o3gF2DoJXVWUcE lkkFpIOYoYxCD2IzprqC44/941cToxG8TuiWU= MIME-Version: 1.0 Received: by 10.114.69.19 with SMTP id r19mr4595052waa.117.1257413811138; Thu, 05 Nov 2009 01:36:51 -0800 (PST) From: S Arvind Date: Thu, 5 Nov 2009 15:06:31 +0530 Message-ID: Subject: Running some query in low priority To: pgsql-performance@postgresql.org Content-Type: multipart/alternative; boundary=00504502e8c28c72fa04779c7706 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.598 tagged_above=-10 required=5 tests=BAYES_00=-2.599, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200911/61 X-Sequence-Number: 36229 --00504502e8c28c72fa04779c7706 Content-Type: text/plain; charset=ISO-8859-1 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? Arvind S * "Many of lifes failure are people who did not realize how close they were to success when they gave up." -Thomas Edison* --00504502e8c28c72fa04779c7706 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi Developers and Tuners,
=A0=A0=A0=A0=A0=A0=A0=A0 Is there any way to r= un 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 und= isturbed by the sub application(low priority) which is running on same DB. = Is there anyother good way to operate this?

Arvind S


"Many of lif= es failure are people who did not realize how close they were to success wh= en they gave up."
-Thomas Edison
--00504502e8c28c72fa04779c7706--