Re: Memory usage after upgrade to 9.2.4

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 <danielcristian(at)gmail(dot)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
クルズ クリスチアン ダニエル