Re: What is pg backend using memory for?

hubert depesz lubaczewski wrote:
> 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

What libraries are loaded in this backend (lsof)?
Maybe it's something non-PostgreSQL that's hogging the memory.

Yours,
Laurenz Albe