Jim C. Nasby wrote:
If you haven't changed checkpoint timeout, this drop-off every 4-6
minutes indicates that you need to make the bgwriter more aggressive.
I'll say to a customer when proposing and explaining.
Thank you for the information.
Regards,
Katsuhiko Okano
okano katsuhiko
Tom Lane [EMAIL PROTECTED] wrote:
Katsuhiko Okano [EMAIL PROTECTED] writes:
It does not solve, even if it increases the number of NUM_SUBTRANS_BUFFERS.
The problem was only postponed.
Can you provide a reproducible test case for this?
Seven machines are required in order to perform
On Fri, Jul 14, 2006 at 02:58:36PM +0900, Katsuhiko Okano wrote:
NOT occurrence of CSStorm. The value of WIPS was about 400.
(but the value of WIPS fell about to 320 at intervals of 4 to 6 minutes.)
If you haven't changed checkpoint timeout, this drop-off every 4-6
minutes indicates that you
Katsuhiko Okano wrote:
By PostgreSQL8.2, NUM_SUBTRANS_BUFFERS was changed into 128
and recompile and measured again.
NOT occurrence of CSStorm. The value of WIPS was about 400.
measured again.
not occurrence when measured for 30 minutes.
but occurrence when measured for 3 hours, and 1 hour and
Katsuhiko Okano [EMAIL PROTECTED] writes:
It does not solve, even if it increases the number of NUM_SUBTRANS_BUFFERS.
The problem was only postponed.
Can you provide a reproducible test case for this?
regards, tom lane
---(end of
Hi.
Alvaro Herrera wrote:
Katsuhiko Okano wrote:
I suspected conflict of BufMappingLock.
but, collected results are seen,
occurrence of CSStorm and the increase of BufMappingLock counts
seem not to correspond.
Instead, SubtransControlLock and SubTrans were increasing.
I do not
Hi,All.
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 10, WIPS=60 or less.
(WIPS = number of web interactions per second)
It is under
Katsuhiko Okano [EMAIL PROTECTED] 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 10, WIPS=60 or less.
Intel Xeon 3.0GHz*4(2CPU
Katsuhiko Okano wrote:
I suspected conflict of BufMappingLock.
but, collected results are seen,
occurrence of CSStorm and the increase of BufMappingLock counts
seem not to correspond.
Instead, SubtransControlLock and SubTrans were increasing.
I do not understand what in the cause of
Katsuhiko,
Have you tried turning HT off? HT is not generally considered (even by
Intel) a good idea for database appplications.
--Josh
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose
hello.
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
11 matches
Mail list logo