Re: Upgrade to dual processor machine?

Hi all,

this is how it looks like, when my system is busy (right now!!!)

50 concurrent visitors at the same time surfing through our web-pages

ps ax | grep postgres:
22568 ? S 0:00 postgres: stats buffer process
22569 ? S 0:00 postgres: stats collector process
22577 ? S 0:15 postgres: postgres kunden 62.116.172.180 INSERT
22578 ? S 0:19 postgres: postgres kunden 62.116.172.180 UPDATE
22582 ? S 0:14 postgres: postgres kunden 62.116.172.180 idle
22583 ? S 0:30 postgres: postgres kunden 62.116.172.180 idle
22584 ? S 0:19 postgres: postgres kunden 62.116.172.180 idle
22586 ? S 0:17 postgres: postgres kunden 62.116.172.180 idle
22587 ? S 0:15 postgres: postgres kunden 62.116.172.180 idle
22588 ? S 0:20 postgres: postgres kunden 62.116.172.180 INSERT
22590 ? S 0:15 postgres: postgres kunden 62.116.172.180 INSERT
22592 ? S 0:18 postgres: postgres kunden 62.116.172.180 INSERT
22593 ? S 0:15 postgres: postgres kunden 62.116.172.180 idle
22594 ? S 0:19 postgres: postgres kunden 62.116.172.180 UPDATE
22601 ? D 0:22 postgres: postgres kunden 62.116.172.180 SELECT
22643 ? S 0:14 postgres: postgres kunden 62.116.172.180 idle
22730 ? D 0:10 postgres: postgres kunden 62.116.172.180 SELECT
22734 ? D 0:08 postgres: postgres kunden 62.116.172.180 SELECT
22753 ? S 0:10 postgres: postgres kunden 62.116.172.180 SELECT
22754 ? S 0:05 postgres: postgres kunden 62.116.172.180 idle
22755 ? S 0:02 postgres: postgres kunden 62.116.172.180 idle
22756 ? S 0:02 postgres: postgres kunden 62.116.172.180 idle
22762 ? S 0:05 postgres: postgres kunden 62.116.172.180 UPDATE
22764 ? D 0:04 postgres: postgres kunden 62.116.172.180 SELECT
22765 ? S 0:02 postgres: postgres kunden 62.116.172.180 UPDATE
22766 ? D 0:02 postgres: postgres kunden 62.116.172.180 SELECT
22787 ? S 0:02 postgres: postgres kunden 62.116.172.180 idle
22796 ? S 0:00 postgres: postgres kunden 62.116.172.180 UPDATE
22803 ? S 0:00 postgres: postgres kunden 62.116.172.180 idle
22804 ? S 0:01 postgres: postgres kunden 62.116.172.180 idle
22805 ? S 0:01 postgres: postgres kunden 62.116.172.180 idle
22806 ? S 0:00 postgres: postgres kunden 62.116.172.180 idle
22807 ? S 0:00 postgres: postgres kunden 62.116.172.180 idle
22809 ? D 0:00 postgres: postgres kunden 62.116.172.180 SELECT
22814 ? S 0:01 postgres: postgres kunden 62.116.172.180 idle
22815 ? D 0:03 postgres: postgres kunden 62.116.172.180 SELECT
22818 ? S 0:00 postgres: postgres kunden 62.116.172.180 idle
22821 ? S 0:00 postgres: postgres kunden 62.116.172.180 idle
22824 ? S 0:01 postgres: postgres kunden 62.116.172.180 UPDATE
22825 ? S 0:00 postgres: postgres kunden 62.116.172.180 UPDATE
22829 ? S 0:00 postgres: checkpoint subprocess
22830 ? S 0:00 postgres: postgres kunden 62.116.172.180 INSERT
22832 pts/0 S 0:00 grep postgres

-> I count 20 concurrent database queries above ...

vmstat 1 5:
procs memory swap io system cpu
r b w swpd free buff cache si so bi bo in cs us sy id
1 8 1 60 4964 5888 309684 0 0 176 74 16 32 25 9 66
0 6 3 60 4964 5932 308772 0 0 6264 256 347 347 13 9 78
0 5 1 60 4964 5900 309364 0 0 9312 224 380 309 11 6 83
1 4 1 60 5272 5940 309152 0 0 10320 116 397 429 17 6 77
1 4 1 60 4964 5896 309512 0 0 11020 152 451 456 14 10 76

free:
total used free shared buffers cached
Mem: 1020808 1015860 4948 531424 5972 309548
-/+ buffers/cache: 700340 320468
Swap: 1028112 60 1028052

w:
12:04pm up 2 days, 17:44, 1 user, load average: 10.28, 7.22, 3.88
USER TTY FROM LOGIN@ IDLE JCPU PCPU WHAT
root pts/0 condor.city-map. 11:46am 0.00s 0.09s 0.01s w

this is when things begin to go more slowly....

any advice?

--

Mit freundlichem Gruß

Henrik Steffen
Geschäftsführer

top concepts Internetmarketing GmbH
Am Steinkamp 7 - D-21684 Stade - Germany
--------------------------------------------------------
http://www.topconcepts.com Tel. +49 4141 991230
mail: steffen(at)topconcepts(dot)com Fax. +49 4141 991233
--------------------------------------------------------
24h-Support Hotline: +49 1908 34697 (EUR 1.86/Min,topc)
--------------------------------------------------------
Ihr SMS-Gateway: JETZT NEU unter: http://sms.city-map.de
System-Partner gesucht: http://www.franchise.city-map.de
--------------------------------------------------------
Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563
--------------------------------------------------------