Hello
The postgresql eat resources. Any suggestions?
-------------------------
top - 11:14:48 up 23:43, 3 users, load average: 33.13, 32.53, 29.54
Tasks: 165 total, 5 running, 148 sleeping, 12 stopped, 0 zombie
Cpu(s): 0.1% us, 30.8% sy, 8.7% ni, 60.3% id, 0.2% wa, 0.0% hi, 0.0% si
Mem: 4149152k total, 3086236k used, 1062916k free, 325724k buffers
Swap: 2040212k total, 576k used, 2039636k free, 1873972k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
15078 postgres 18 0 20600 2732 1948 R 99.8 0.1 75:44.30 postmaster
12870 root 39 19 168m 95m 4636 R 56.9 2.4 0:01.71 httpd
2805 named 18 0 101m 35m 2332 S 0.3 0.9 4:19.20 named
2907 root 34 19 0 0 0 R 0.3 0.0 0:57.05 kipmi0
17712 root 16 0 2516 1180 804 R 0.3 0.0 1:58.45 top
1 root 16 0 3300 628 532 S 0.0 0.0 0:02.30 init
-------------------------
User Domain %CPU %MEM MySQL Processes
postgres 7.39 0.00 0.0
Top Process %CPU 100 postgres: checkpoint subprocess
Top Process %CPU 99.9 postgres: checkpoint subprocess
root 5.72 6.49 1.9
Top Process %CPU 85.0 netstat -nlp
Top Process %CPU 57.0 netstat -nlp
Top Process %CPU 42.0 netstat -nlp
Thank you
Konrath
The postgresql eat resources. Any suggestions?
-------------------------
top - 11:14:48 up 23:43, 3 users, load average: 33.13, 32.53, 29.54
Tasks: 165 total, 5 running, 148 sleeping, 12 stopped, 0 zombie
Cpu(s): 0.1% us, 30.8% sy, 8.7% ni, 60.3% id, 0.2% wa, 0.0% hi, 0.0% si
Mem: 4149152k total, 3086236k used, 1062916k free, 325724k buffers
Swap: 2040212k total, 576k used, 2039636k free, 1873972k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
15078 postgres 18 0 20600 2732 1948 R 99.8 0.1 75:44.30 postmaster
12870 root 39 19 168m 95m 4636 R 56.9 2.4 0:01.71 httpd
2805 named 18 0 101m 35m 2332 S 0.3 0.9 4:19.20 named
2907 root 34 19 0 0 0 R 0.3 0.0 0:57.05 kipmi0
17712 root 16 0 2516 1180 804 R 0.3 0.0 1:58.45 top
1 root 16 0 3300 628 532 S 0.0 0.0 0:02.30 init
-------------------------
User Domain %CPU %MEM MySQL Processes
postgres 7.39 0.00 0.0
Top Process %CPU 100 postgres: checkpoint subprocess
Top Process %CPU 99.9 postgres: checkpoint subprocess
root 5.72 6.49 1.9
Top Process %CPU 85.0 netstat -nlp
Top Process %CPU 57.0 netstat -nlp
Top Process %CPU 42.0 netstat -nlp
Thank you
Konrath
Last edited:
