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

RES: Priority to a mission critical transaction

From: "Carlos H(dot) Reimer" <carlos(dot)reimer(at)opendb(dot)com(dot)br>
To: "Jim C(dot) Nasby" <jim(at)nasby(dot)net>,"Brad Nicholson" <bnichols(at)ca(dot)afilias(dot)info>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: RES: Priority to a mission critical transaction
Date: 2006-11-28 19:01:25
Message-ID: PEEPKDFEHHEMKBBFPOOKMEAIDKAA.carlos.reimer@opendb.com.br (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-performance
Hi,

There is an article about "Lowering the priority of a PostgreSQL query"
(http://weblog.bignerdranch.com/?p=11) that explains how to use the
setpriority() to lower PostgreSQL processes.

I?m wondering how much effective it would be for i/o bound systems.

Will the setpriority() system call affect i/o queue too?

Reimer


> -----Mensagem original-----
> De: Jim C. Nasby [mailto:jim(at)nasby(dot)net]
> Enviada em: domingo, 26 de novembro de 2006 22:52
> Para: Brad Nicholson
> Cc: carlos(dot)reimer(at)opendb(dot)com(dot)br; pgsql-performance(at)postgresql(dot)org
> Assunto: Re: [PERFORM] Priority to a mission critical transaction
>
>
> 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(at)nasby(dot)net
> EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)
>
>


In response to

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2006-11-28 19:07:05
Subject: Re: RES: Priority to a mission critical transaction
Previous:From: J. Andrew RogersDate: 2006-11-28 16:51:05
Subject: Re: Postgres scalability and performance on windows

pgsql-advocacy by date

Next:From: Tom LaneDate: 2006-11-28 19:07:05
Subject: Re: RES: Priority to a mission critical transaction
Previous:From: Roderick A. AndersonDate: 2006-11-28 18:54:43
Subject: Re: Collateral for LISA 06

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