I think I didn't make it clear: the session memory usage is growing up too fast, until all server memory got used and swap occurs.
Never saw something like that. The version is under a test enviroment for a long time... Thanks if someone could help me. 2013/4/20 Daniel Cristian Cruz <danielcrist...@gmail.com> > 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 > クルズ クリスチアン ダニエル > -- Daniel Cristian Cruz クルズ クリスチアン ダニエル
