Postgres Pro
Downloads
Home   >   mailing lists

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

From Brad Nicholson
Subject Re: Priority to a mission critical transaction
Date
Msg-id 1164314415.21439.32.camel@dba5.int.libertyrms.com
Whole thread Raw
In response to Priority to a mission critical transaction  ("Carlos H. Reimer" <carlos.reimer@opendb.com.br>)
Responses Re: Priority to a mission critical transaction
List pgsql-performance
Tree view 
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.

--
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: Direct I/O issues
Next
From: "Gopal"
Date:
Subject: Postgres scalability and performance on windows