Re: Hope for a new PostgreSQL era? - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Hope for a new PostgreSQL era?
Date
Msg-id 20111208132056.GD25704@shinkuro.com
Whole thread Raw
In response to Re: Hope for a new PostgreSQL era?  ("Tomas Vondra" <tv@fuzzy.cz>)
Responses Re: Hope for a new PostgreSQL era?  ("Tomas Vondra" <tv@fuzzy.cz>)
List pgsql-general
On Thu, Dec 08, 2011 at 01:53:45PM +0100, Tomas Vondra wrote:
> I wonder if the prioritisation could be done using nice - each backend is
> a separate process, so why not to do 'nice(10)' for low priority processes
> or something like that.

This won't work because if you are holding a lock on something someone
else needs, your low nice score is going to cause them problems.  It
could make things worse rather than better.  (This suggestion comes up
a lot, by the way, so there's been a lot of discussion of it
historically.)

--
Andrew Sullivan
ajs@crankycanuck.ca


pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Hope for a new PostgreSQL era?
Next
From: Satoshi Nagayasu
Date:
Subject: Re: Hope for a new PostgreSQL era?