Pessoal, Estamos com uma problema que não conseguimos identificar o motivo. Máquina com 36 cores, 128GB de RAM, Postgres 9.3.12. o % system do TOP às vezes chega quase a 99% e o %user menos de 1% Temos o bouncer na frente do banco pra grande maioria das aplicações. No final das contas, nem chegam 200 conexões no banco.
A máquina está sozinha nesse server, mas com VMWare embaixo. Alguém já passou por isso? E o que pode ser? top - 09:43:38 up 17 days, 14:29, 5 users, load average: 31.30, 31.00, 34.48 Tasks: 843 total, 25 running, 818 sleeping, 0 stopped, 0 zombie Cpu(s): 0.2%us, 63.7%sy, 0.0%ni, 36.0%id, 0.1%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 132151868k total, 130079408k used, 2072460k free, 76140k buffers Swap: 524280k total, 0k used, 524280k free, 117686160k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 52096 postgres 20 0 16.7g 5.5g 5.4g R 100.0 4.4 3:51.68 postgres: user_pje_jud1g pje_jud1g_descanso_p 192.168.252.43(37249) SEL 33783 postgres 20 0 16.7g 7.1g 7.0g R 100.0 5.6 14:17.42 postgres: user_pje_jud1g pje_jud1g_descanso_p 192.168.252.43(37109) SEL 40830 postgres 20 0 16.7g 6.2g 6.1g R 100.0 4.9 13:14.98 postgres: user_pje_jud1g pje_jud1g_descanso_p 192.168.252.43(37160) SEL 51112 postgres 20 0 16.7g 5.3g 5.2g R 100.0 4.2 4:12.24 postgres: user_pje_jud1g pje_jud1g_descanso_p 192.168.252.43(37242) SEL 24496 postgres 20 0 16.7g 6.9g 6.9g R 100.0 5.5 21:34.21 postgres: user_pje_jud1g pje_jud1g_descanso_p 192.168.252.43(37060) SEL 48363 postgres 20 0 16.7g 5.5g 5.4g R 100.0 4.4 4:29.58 postgres: user_pje_jud1g pje_jud1g_descanso_p 192.168.252.43(37218) SEL 49852 postgres 20 0 16.7g 5.8g 5.8g R 100.0 4.6 4:05.84 postgres: user_pje_jud1g pje_jud1g_descanso_p 192.168.252.43(37231) SEL 35325 postgres 20 0 16.7g 6.2g 6.1g R 99.4 4.9 12:07.39 postgres: user_pje_jud1g pje_jud1g_descanso_p 192.168.252.43(37124) SELE 47279 postgres 20 0 16.7g 5.6g 5.6g R 99.4 4.5 6:00.16 postgres: user_pje_jud1g pje_jud1g_descanso_p 192.168.252.43(37203) SELE 45463 postgres 20 0 16.7g 5.4g 5.3g R 99.0 4.3 6:47.36 postgres: user_pje_jud1g pje_jud1g_descanso_p 192.168.252.43(37186) SELE 51045 postgres 20 0 16.7g 2.8g 2.7g R 98.3 2.2 3:06.55 postgres: user_pje_jud1g pje_jud1g_descanso_p 192.168.252.43(37240) BIND 40000 postgres 20 0 16.8g 6.2g 6.1g R 96.6 4.9 9:49.28 postgres: user_pje_jud1g pje_jud1g_descanso_p 192.168.252.43(37152) SELE 46272 postgres 20 0 16.7g 5.6g 5.6g R 95.9 4.5 7:30.99 postgres: user_pje_jud1g pje_jud1g_descanso_p 192.168.252.43(37196) SELE 48130 postgres 20 0 16.7g 5.1g 5.1g R 92.6 4.1 3:53.43 postgres: user_pje_jud1g pje_jud1g_descanso_p 192.168.252.43(37213) SELE 24887 postgres 20 0 16.7g 7.3g 7.3g R 90.2 5.8 21:51.11 postgres: user_pje_jud1g pje_jud1g_descanso_p 192.168.252.43(37085) SELE 44341 postgres 20 0 16.7g 3.1g 3.1g R 89.7 2.5 6:35.79 postgres: user_pje_jud1g pje_jud1g_descanso_p 192.168.252.43(37182) SELE 45226 postgres 20 0 16.7g 5.3g 5.2g R 87.9 4.2 5:24.62 postgres: user_pje_jud1g pje_jud1g_descanso_p 192.168.252.43(37185) BIND 23489 postgres 20 0 16.7g 6.9g 6.8g R 82.9 5.4 20:21.00 postgres: user_pje_jud1g pje_jud1g_descanso_p 192.168.252.43(37043) SELE 55928 postgres 20 0 16.7g 1.3g 1.3g R 73.2 1.1 0:51.00 postgres: user_pje_jud1g pje_jud1g_descanso_p 192.168.252.43(37267) SELE
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
