Re: My own performance/tuning q&a - Mailing list pgsql-performance

From Bruce Momjian
Subject Re: My own performance/tuning q&a
Date
Msg-id 200310242050.h9OKoYX22829@candle.pha.pa.us
Whole thread Raw
In response to Re: My own performance/tuning q&a  (Vivek Khera <khera@kcilink.com>)
Responses Re: My own performance/tuning q&a
List pgsql-performance
Vivek Khera wrote:
> >>>>> "sm" == scott marlowe <scott.marlowe> writes:
>
>
> sm> Note that Tom has mentioned problems with possible deadlocks when nicing
> sm> individual backends before, so proceed with caution here.
>
> I can see possible starvation, but if scheduling changes cause
> deadlocks, then there's something wrong with the design.

Yes, I think Tom's concern was priority inversion, where a low priority
process holds a lock while a higher one waits for it.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-performance by date:

Previous
From: Richard Jones
Date:
Subject: Memcache
Next
From: Hannu Krosing
Date:
Subject: Re: Performance Concern