Boa tarde Srs
Estou usando postgresql 8.4.7-1.el5_6.1 em Centos 5.7. Misteriosamente meu
postgresql passou a rodar em 100% da cpu, sem motivo algum. Não tenho volume
grande de consultas nem atualizações. Andei lendo em forums sobre esse
problema mais nao cheguei a conclusão alguma, alguns sugeriram para
desabilitar o autovacuum mais não resolveu.
Não foi modificado nada em termos de hardware/software/tabelas nos últimos
meses, isso que mais me estranha.
Segue alguns dados
Iostat indicia que não ha disco em uso (descarto o problema ser disco)
#iostat 1
Linux 2.6.18-274.3.1.el5 10/10/2011
avg-cpu: %user %nice %system %iowait %steal %idle
62.68 0.00 0.12 0.72 0.00 36.47
Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
sda 2.50 72.94 175.53 3280788 7895330
sda1 0.00 0.03 0.00 1544 18
sda2 0.00 0.04 0.04 1915 1928
sda3 0.00 0.03 0.01 1297 360
sda4 0.00 0.00 0.00 6 0
sda5 2.49 72.82 175.48 3275594 7893024
sdb 21.90 544.12 35.31 24474050 1588112
avg-cpu: %user %nice %system %iowait %steal %idle
100.00 0.00 0.00 0.00 0.00 0.00
Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
sda 5.00 32.00 128.00 32 128
sda1 0.00 0.00 0.00 0 0
sda2 0.00 0.00 0.00 0 0
sda3 0.00 0.00 0.00 0 0
sda4 0.00 0.00 0.00 0 0
sda5 5.00 32.00 128.00 32 128
sdb 0.00 0.00 0.00 0 0
avg-cpu: %user %nice %system %iowait %steal %idle
100.00 0.00 0.00 0.00 0.00 0.00
Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
sda 0.00 0.00 0.00 0 0
sda1 0.00 0.00 0.00 0 0
sda2 0.00 0.00 0.00 0 0
sda3 0.00 0.00 0.00 0 0
sda4 0.00 0.00 0.00 0 0
sda5 0.00 0.00 0.00 0 0
sdb 0.00 0.00 0.00 0 0
# vmstat 1
procs -----------memory---------- ---swap-- -----io---- --system--
-----cpu------
r b swpd free buff cache si so bi bo in cs us sy id
wa st
9 0 188 61936 65660 6757584 0 0 77 26 26 45 63 0 36
1 0
8 0 188 61936 65668 6757676 0 0 0 56 1012 110 100 0 0
0 0
10 0 188 61936 65676 6757668 0 0 0 16 1020 109 100 0 0
0 0
7 0 188 61936 65676 6757676 0 0 0 0 1007 104 100 0 0
0 0
8 0 188 61936 65676 6757676 0 0 0 0 1029 101 100 0 0
0 0
7 0 188 62060 65676 6757676 0 0 0 0 1005 102 100 0 0
0 0
7 0 188 62060 65684 6757668 0 0 0 12 1006 100 100 0 0
0 0
7 0 188 62060 65692 6757676 0 0 0 64 1017 108 100 0 0
0 0
top - 13:13:22 up 12:32, 1 user, load average: 8.06, 8.02, 7.93
Tasks: 122 total, 8 running, 114 sleeping, 0 stopped, 0 zombie
Cpu(s): 62.8%us, 0.1%sy, 0.0%ni, 36.3%id, 0.7%wa, 0.0%hi, 0.0%si,
0.0%st
Mem: 8132952k total, 8072156k used, 60796k free, 65812k buffers
Swap: 2096472k total, 188k used, 2096284k free, 6758564k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
11603 postgres 25 0 4422m 450m 345m R 97.7 5.7 137:40.71 postmaster
11592 postgres 25 0 4438m 548m 426m R 55.8 6.9 177:06.76 postmaster
11620 postgres 25 0 4422m 400m 294m R 53.9 5.0 114:22.75 postmaster
11584 postgres 25 0 4438m 571m 449m R 49.9 7.2 186:51.54 postmaster
11611 postgres 25 0 4422m 447m 342m R 47.9 5.6 135:43.10 postmaster
11596 postgres 25 0 4398m 462m 381m R 45.9 5.8 155:16.81 postmaster
11616 postgres 25 0 4422m 406m 301m R 43.9 5.1 117:41.52 postmaster
11583 postgres 15 0 4331m 4.0g 4.0g S 2.0 52.0 16:16.13 postmaster
1 root 15 0 10368 628 536 S 0.0 0.0 0:00.58 init
2 root RT -5 0 0 0 S 0.0 0.0 0:00.00 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/0
4 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/0
5 root RT -5 0 0 0 S 0.0 0.0 0:00.00 migration/1
6 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/1
7 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/1
8 root RT -5 0 0 0 S 0.0 0.0 0:00.00 migration/2
9 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/2
10 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/2
11 root RT -5 0 0 0 S 0.0 0.0 0:00.00 migration/3
Giancarlo Rubio
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
