Re: poor performance with Context Switch Storm at TPC-W. - Mailing list pgsql-hackers

From Qingqing Zhou
Subject Re: poor performance with Context Switch Storm at TPC-W.
Date
Msg-id e907on$1csr$1@news.hub.org
Whole thread Raw
In response to poor performance with Context Switch Storm at TPC-W.  (Katsuhiko Okano <okano.katsuhiko@oss.ntt.co.jp>)
Responses Re: poor performance with Context Switch Storm at TPC-W.
List 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 by date:

Previous
From: Thomas Hallgren
Date:
Subject: Re: Three weeks left until feature freeze
Next
From: Bruce Momjian
Date:
Subject: Cleanup of include files