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?"
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