Re: Wierd context-switching issue on Xeon

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Wierd context-switching issue on Xeon
Дата
Msg-id 200404291121.51247.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: Wierd context-switching issue on Xeon  (Robert Creager <Robert_Creager@LogicalChaos.org>)
Ответы Re: Wierd context-switching issue on Xeon  (Robert Creager <Robert_Creager@LogicalChaos.org>)
Список pgsql-performance
Rob,

> I would like to see the same, as I have a system that exhibits the same
behavior
> on a production db that's running 7.4.1.

If you checked the thread follow-ups,  you'd see that *decreasing*
spins_per_delay was not beneficial.   Instead, try increasing them, one step
at a time:

(take baseline measurement at 100)
250
500
1000
1500
2000
3000
5000

... until you find an optimal level.   Then report the results to us!

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


В списке pgsql-performance по дате отправления:

Предыдущее
От: "Gary Doades"
Дата:
Сообщение: Re: planner/optimizer question
Следующее
От: Rod Taylor
Дата:
Сообщение: Re: planner/optimizer question