pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jim C. Nasby <decibel@decibel.org>
To: Ron Mayer <rm_pg@cheapcomplexdevices.com>
To: pgsql-general@postgresql.org
Subject: Re: Priorities for users or queries?
Date: Fri, 23 Feb 2007 16:38:27 -0600
Message-ID: <20070223223826.GC11743@decibel.org> (raw)
In-Reply-To: <45DF499C.4090305@cheapcomplexdevices.com>
References: <45D65E08.7000306@cheapcomplexdevices.com>
	<200702170152.l1H1qax16645@momjian.us>
	<45DB81EA.9080401@cheapcomplexdevices.com>
	<EEC21951-FCCA-432A-959D-48D8D8425C96@decibel.org>
	<45DF499C.4090305@cheapcomplexdevices.com>

On Fri, Feb 23, 2007 at 12:07:56PM -0800, Ron Mayer wrote:
> Jim Nasby wrote:
> > The problem with using simple OS priority settings is you leave yourself
> > wide open to priority inversion.
> 
> Which is why you either
>  (a) note that papers studying priority inversion on RDBMS's
>      find that it's a non issue on many RDBMS workloads; and
>      (except for real-time databases) you tend to still get
>      at least partial benefits even in the face of priority
>      inversions.
> or
>  (b) use a scheduler in your OS that supports priority
>      inheritance or other mechanisms to avoid priority
>      inversion problems.
>      If you want to use priority inheritance to avoid
>      the priority inversion settings it appears versions
>      of Linux, BSD, Windows, and Solaris at least give
>      you the ability to do so.
> 
> > There is already work being done on a queuing system; take a look at the
> > bizgres archives.
> 
> Which is cool; but not quite the same as priorities.
> 
> It seems to me that Bizgres and/or PostgreSQL would not
> want to re-implement OS features like schedulers.

Actually, I believe part of the discussion also involved how to handle
long-running workloads that you don't want to monopolize the machine.
-- 
Jim C. Nasby, Database Architect                decibel@decibel.org 
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"



view thread (30+ messages)  latest in thread

Message-ID: <20070223223826.GC11743@decibel.org>
Permalink:  ../20070223223826.GC11743@decibel.org/
Also on:    postgresql.org/message-id/20070223223826.GC11743@decibel.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: decibel@decibel.org, rm_pg@cheapcomplexdevices.com, pgsql-general@postgresql.org
  Subject: Re: Priorities for users or queries?
  In-Reply-To: <20070223223826.GC11743@decibel.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox