What is pg backend using memory for?

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/

Responses

Browse pgsql-general by date

  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