Re: My own performance/tuning q&a

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: My own performance/tuning q&a
Дата
Msg-id 200310242050.h9OKoYX22829@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: My own performance/tuning q&a  (Vivek Khera <khera@kcilink.com>)
Ответы Re: My own performance/tuning q&a
Список 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 по дате отправления:

Предыдущее
От: Richard Jones
Дата:
Сообщение: Memcache
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: Performance Concern