Hi all, I've upgrade from 9.1.4 to 9.2.4, and got some very weird issue.
My server got connections with RES (column from top utility) with too much memory: top - 19:50:58 up 384 days, 23:55, 2 users, load average: 4.28, 6.51, 7.68 Tasks: 417 total, 1 running, 416 sleeping, 0 stopped, 0 zombie Cpu(s): 0.5%us, 0.4%sy, 0.0%ni, 94.8%id, 4.3%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 98923768k total, 53750228k used, 45173540k free, 46192k buffers Swap: 49150856k total, 24147924k used, 25002932k free, 32706740k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 10522 pg92 17 0 16.7g 7.9g 1.7g S 0.0 8.4 2:44.69 postgres: sgn2 senai 10.1.3.1(24675) idle 9367 pg92 17 0 16.6g 6.7g 517m S 0.0 7.1 5:05.98 postgres: sgn2 senai 10.1.3.1(44277) idle 13336 pg92 17 0 16.5g 6.6g 511m S 0.0 7.0 0:14.01 postgres: sgn2 senai 10.1.3.1(51436) idle 26864 pg92 18 0 6487m 6.0g 6.0g S 0.0 6.3 3:20.21 postgres: pg92 senai [local] idle 14360 pg92 15 0 6461m 1.2g 1.2g S 0.0 1.3 0:02.46 postgres: integracao senai 10.1.3.200(59197) idle 14678 pg92 15 0 6461m 1.2g 1.2g S 0.0 1.3 0:01.34 postgres: integracao senai 10.1.3.200(59201) idle 10597 pg92 17 0 6513m 878m 830m S 0.0 0.9 0:08.81 postgres: integracao senai 10.1.3.200(38519) idle 9301 pg92 15 0 6456m 188m 187m S 0.0 0.2 0:08.98 /home/pg92/bin/postgres 9408 pg92 17 0 6483m 115m 91m S 0.0 0.1 3:02.13 postgres: sgn2 senai 10.1.3.1(44310) idle 9306 pg92 15 0 6459m 72m 70m S 0.0 0.1 0:00.93 postgres: writer process 9305 pg92 16 0 6459m 60m 59m S 0.0 0.1 0:00.13 postgres: checkpointer process 15028 pg92 16 0 6462m 54m 51m S 0.0 0.1 0:00.07 postgres: integracao senai 10.1.3.200(59203) idle 17779 pg92 15 0 6464m 23m 19m S 0.0 0.0 0:00.30 postgres: sgn2 senai 10.1.3.1(34656) idle 9307 pg92 15 0 6459m 6020 5392 S 0.0 0.0 0:00.01 postgres: wal writer process 9308 pg92 15 0 6462m 4584 1740 S 0.0 0.0 0:04.94 postgres: autovacuum launcher process 17766 pg92 16 0 6460m 3968 2340 S 0.0 0.0 0:00.00 postgres: sgn2 senai 10.1.3.1(34642) idle 17767 pg92 16 0 6460m 3968 2340 S 0.0 0.0 0:00.00 postgres: sgn2 senai 10.1.3.1(62906) idle (many other conns) I don't know why this is happening. I'm stuck with all the same parameters from 9.1.4. The only solution right now is to rollback to the older version. Does someone got something like this before? Thanks, -- Daniel Cristian Cruz クルズ クリスチアン ダニエル
