Re: Priority to a mission critical transaction - Mailing list pgsql-performance

From Jim C. Nasby
Subject Re: Priority to a mission critical transaction
Date
Msg-id 20061127005143.GJ39519@nasby.net
Whole thread Raw
In response to Re: Priority to a mission critical transaction  (Brad Nicholson <bnichols@ca.afilias.info>)
Responses RES: Priority to a mission critical transaction
List pgsql-performance
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)

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Postgres server crash
Next
From: "Jim C. Nasby"
Date:
Subject: Re: When to vacuum a table?