Memory usage after upgrade to 9.2.4

From: Daniel Cristian Cruz <danielcristian(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Memory usage after upgrade to 9.2.4
Date: 2013-04-20 23:00:18
Message-ID: CACffM9F-aSTopQ3G0mZvyWusp=RPZ=MmnPn26MKVtDb5r-JaDw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
クルズ クリスチアン ダニエル

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Cristian Cruz 2013-04-20 23:08:25 Re: Memory usage after upgrade to 9.2.4
Previous Message Alban Hertroys 2013-04-20 22:24:00 Re: UPDATE with subquery; possible bug in query parser?