Memory usage after upgrade to 9.2.4 - Mailing list pgsql-general
| From | Daniel Cristian Cruz |
|---|---|
| Subject | Memory usage after upgrade to 9.2.4 |
| Date | |
| Msg-id | CACffM9F-aSTopQ3G0mZvyWusp=RPZ=MmnPn26MKVtDb5r-JaDw@mail.gmail.com Whole thread Raw |
| Responses |
Re: Memory usage after upgrade to 9.2.4
|
| List | pgsql-general |
Hi all,
Daniel Cristian Cruz
クルズ クリスチアン ダニエル
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
クルズ クリスチアン ダニエル
pgsql-general by date: