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.
|
| Список | 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 по дате отправления: