Context Switching issue: Spinlock doesn't fix.

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Context Switching issue: Spinlock doesn't fix.
Дата
Msg-id 200406021225.25463.josh@agliodbs.com
обсуждение исходный текст
Ответы Re: Context Switching issue: Spinlock doesn't fix.  (jelle <jellej@pacbell.net>)
Список pgsql-performance
Folks,

I've been testing varying SPINS_PER_DELAY in a client's installation of
PostgreSQL against a copy of a production database, to test varying this
statistic as a way of fixing the issue.

It does not seem to work.

I've tested all of the following graduated levels:

100 (the original)
250
500
1000
2000
5000
10000
20000
30000
50000

None of these quantities seem to make any difference at all in the number of
context switches -- neither down nor up.   Seems to me like this is a dead
end.   Does anyone have test results that show otherwise?

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


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

Предыдущее
От: "Leeuw van der, Tim"
Дата:
Сообщение: Re: PostgreSQL on VMWare vs Windows vs CoLinux
Следующее
От: "W.H. van Atteveldt"
Дата:
Сообщение: Postgres query optimization with varchar fields