Re: Proposal of tunable fix for scalability of 8.4
От | decibel |
---|---|
Тема | Re: Proposal of tunable fix for scalability of 8.4 |
Дата | |
Msg-id | D4B5954C-4E01-40B7-BC6E-F98842593889@decibel.org обсуждение исходный текст |
Ответ на | Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah" <J.K.Shah@Sun.COM>) |
Ответы |
Re: Proposal of tunable fix for scalability of 8.4
|
Список | pgsql-performance |
On Mar 13, 2009, at 3:02 PM, Jignesh K. Shah wrote: > vmstat seems similar to wakeup some > kthr memory page disk > faults cpu > r b w swap free re mf pi po fr de sr s0 s1 s2 sd in sy > cs us sy id > 63 0 0 45535728 38689856 0 14 0 0 0 0 0 0 0 0 0 163318 334225 > 360179 47 17 36 > 85 0 0 45436736 38690760 0 6 0 0 0 0 0 0 0 0 0 165536 347462 > 365987 47 17 36 > 59 0 0 45405184 38681752 0 11 0 0 0 0 0 0 0 0 0 155153 326182 > 345527 47 16 37 > 53 0 0 45393816 38673344 0 6 0 0 0 0 0 0 0 0 0 152752 317851 > 340737 47 16 37 > 66 0 0 45378312 38651920 0 11 0 0 0 0 0 0 0 0 0 150979 304350 > 336915 47 16 38 > 67 0 0 45489520 38639664 0 5 0 0 0 0 0 0 0 0 0 157188 318958 > 351905 47 16 37 > 82 0 0 45483600 38633344 0 10 0 0 0 0 0 0 0 0 0 168797 348619 > 375827 47 17 36 > 68 0 0 45463008 38614432 0 9 0 0 0 0 0 0 0 0 0 173020 376594 > 385370 47 18 35 > 54 0 0 45451376 38603792 0 13 0 0 0 0 0 0 0 0 0 161891 342522 > 364286 48 17 35 > 41 0 0 45356544 38605976 0 5 0 0 0 0 0 0 0 0 0 167250 358320 > 372469 47 17 36 > 27 0 0 45323472 38596952 0 11 0 0 0 0 0 0 0 0 0 165099 344695 > 364256 48 17 35 The good news is there's now at least enough runnable procs. What I find *extremely* odd is the CPU usage is almost dead constant... -- Decibel!, aka Jim C. Nasby, Database Architect decibel@decibel.org Give your computer some brain candy! www.distributed.net Team #1828
В списке pgsql-performance по дате отправления: