From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | What is pg backend using memory for? |
Date: | 2013-04-09 16:40:05 |
Message-ID: | 20130409164005.GA3909@depesz.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
So, I checked a backend on Linux, and found such thing:
2ba63c797000-2ba63fa68000 rw-p 2ba63c797000 00:00 0
Size: 52036 kB
Rss: 51336 kB
Shared_Clean: 0 kB
Shared_Dirty: 0 kB
Private_Clean: 0 kB
Private_Dirty: 51336 kB
Swap: 0 kB
Pss: 51336 kB
(this is part of /proc/<pid>/smaps).
This is not shared memory, so it's local. It's not related to any files (in such case first line would have path to file).
What's more - this backend, during getting smaps copy was idle, and it's not stats manager, or anything like this.
How can this be diagnosed, to find out why there is so much private
memory?
In case it matters: it's pg 9.1.6 on linux 2.6.18-164.2.1.el5
Best regards,
depesz
--
The best thing about modern society is how easy it is to avoid contact with it.
http://depesz.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Ramsey Gurley | 2013-04-09 16:52:01 | Re: Inconsistent query performance |
Previous Message | Merlin Moncure | 2013-04-09 16:28:42 | Re: Create a DBLink from PostrgeSQL 9.2 to Oracle 11g |