Re: Proposal of tunable fix for scalability of 8.4

From: decibel <decibel(at)decibel(dot)org>
To: Jignesh K(dot) Shah <J(dot)K(dot)Shah(at)Sun(dot)COM>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Proposal of tunable fix for scalability of 8.4
Date: 2009-03-14 15:40:18
Message-ID: D4B5954C-4E01-40B7-BC6E-F98842593889@decibel.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2009-03-14 15:52:05 Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4
Previous Message decibel 2009-03-14 15:27:01 Re: Proposal of tunable fix for scalability of 8.4