Re: Upgrade to dual processor machine? - Mailing list pgsql-general

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@topconcepts.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
--------------------------------------------------------