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

Re: RES: Priority to a mission critical transaction

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: carlos(dot)reimer(at)opendb(dot)com(dot)br, "Jim C(dot) Nasby" <jim(at)nasby(dot)net>, Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>, pgsql-performance(at)postgresql(dot)org
Subject: Re: RES: Priority to a mission critical transaction
Date: 2006-11-28 23:44:45
Message-ID: 200611282344.kASNijt09203@momjian.us (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-performance
Someone should ask them to remove the article.

---------------------------------------------------------------------------

Tom Lane wrote:
> "Carlos H. Reimer" <carlos(dot)reimer(at)opendb(dot)com(dot)br> writes:
> > 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.
> 
> That article isn't worth the electrons it's written on.  Aside from the
> I/O point, there's a little problem called "priority inversion".  See
> the archives for (many) past discussions of nice'ing backends.
> 
> 			regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
> 
>                 http://www.postgresql.org/about/donate

-- 
  Bruce Momjian   bruce(at)momjian(dot)us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

Responses

pgsql-performance by date

Next:From: Mark KirkwoodDate: 2006-11-29 01:11:12
Subject: Re: RES: Priority to a mission critical transaction
Previous:From: Ron MayerDate: 2006-11-28 20:31:28
Subject: Re: RES: Priority to a mission critical transaction

pgsql-advocacy by date

Next:From: Mark KirkwoodDate: 2006-11-29 01:11:12
Subject: Re: RES: Priority to a mission critical transaction
Previous:From: Josh BerkusDate: 2006-11-28 22:58:23
Subject: Re: Collateral for LISA 06

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