Skip site navigation (1) Skip section navigation (2)

Re: Priority to a mission critical transaction

From: Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>
To: carlos(dot)reimer(at)opendb(dot)com(dot)br
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Priority to a mission critical transaction
Date: 2006-11-23 20:40:15
Message-ID: 1164314415.21439.32.camel@dba5.int.libertyrms.com (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-performance
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.


In response to

Responses

pgsql-performance by date

Next:From: GopalDate: 2006-11-23 22:37:08
Subject: Postgres scalability and performance on windows
Previous:From: Greg SmithDate: 2006-11-23 18:09:54
Subject: Re: Direct I/O issues

pgsql-advocacy by date

Next:From: alfranio correia juniorDate: 2006-11-24 11:53:24
Subject: Re: [Replica-hooks-discuss] Integrating Replication ino
Previous:From: Markus SchiltknechtDate: 2006-11-23 17:26:12
Subject: Re: [Replica-hooks-discuss] Integrating Replication ino

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group