Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 07C499FA6B5 for ; Sun, 26 Nov 2006 20:52:00 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 91896-01 for ; Sun, 26 Nov 2006 20:51:48 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id A04819FA48A for ; Sun, 26 Nov 2006 20:51:48 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id 890E856427; Sun, 26 Nov 2006 18:51:46 -0600 (CST) Received: (hashcash-sendmail, from uid 1001); Sun, 26 Nov 2006 18:51:44 -0600 Date: Sun, 26 Nov 2006 18:51:43 -0600 From: "Jim C. Nasby" To: Brad Nicholson Cc: carlos.reimer@opendb.com.br, pgsql-performance@postgresql.org Subject: Re: Priority to a mission critical transaction Message-ID: <20061127005143.GJ39519@nasby.net> References: <1164314415.21439.32.camel@dba5.int.libertyrms.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1164314415.21439.32.camel@dba5.int.libertyrms.com> X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:061127:bnichols@ca.afilias.info::zSiNIte76p0OdyNk:0000000000000 0000000000000000000000000MyR X-Hashcash: 1:20:061127:carlos.reimer@opendb.com.br::7Q2kyn62jubtzpfg:0000000000 0000000000000000000000007C/h X-Hashcash: 1:20:061127:pgsql-performance@postgresql.org::6XlRy3V7ROu8oxql:00000 0000000000000000000000000GzP X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/230 X-Sequence-Number: 22000 On Thu, Nov 23, 2006 at 03:40:15PM -0500, Brad Nicholson wrote: > On Tue, 2006-11-21 at 21:43 -0200, Carlos H. Reimer wrote: > > Hi, > > > > We have an application that is mission critical, normally very fast, > > but when an I/O or CPU bound transaction appears, the mission critical > > application suffers. Is there a way go give some kind of priority to > > this kind of application? > > Reimer > > > Not that I'm aware of. Depending on what the problems transactions are, > setting up a replica on a separate machine and running those > transactions against the replica might be the solution. The BizGres project has been working on resource quotas, which might eventually evolve to what you're looking for. -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)