Re: poor performance with Context Switch Storm at TPC-W.

Поиск
Список
Период
Сортировка
От Qingqing Zhou
Тема Re: poor performance with Context Switch Storm at TPC-W.
Дата
Msg-id e907on$1csr$1@news.hub.org
обсуждение исходный текст
Ответ на poor performance with Context Switch Storm at TPC-W.  (Katsuhiko Okano <okano.katsuhiko@oss.ntt.co.jp>)
Ответы Re: poor performance with Context Switch Storm at TPC-W.  (Katsuhiko Okano <okano.katsuhiko@oss.ntt.co.jp>)
Список pgsql-hackers
"Katsuhiko Okano" <okano.katsuhiko@oss.ntt.co.jp> wrote
>
> The problem has occurred in my customer.
> poor performance with Context Switch Storm occurred
> with the following composition.
> Usually, CS is about 5000, WIPS=360.
> when CSStorm occurrence, CS is about 100000, WIPS=60 or less.
>
> Intel Xeon 3.0GHz*4(2CPU * H/T ON)
> 4GB Memory

Do you have bgwriter on and what's the parameters? I read a theory somewhere
that bgwriter scan a large portion of memory and cause L1/L2 thrushing, so
with HT on, the other backends sharing the physical processor with it also
get thrashed ... So try to turn bgwriter off or turn HT off see what's the
difference.

Regards,
Qingqing




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

Предыдущее
От: Thomas Hallgren
Дата:
Сообщение: Re: Three weeks left until feature freeze
Следующее
От: Bruce Momjian
Дата:
Сообщение: Cleanup of include files