Re: Still problems with memory swapping and server load

Alvar Freude <alvar(at)a-blast(dot)org> writes:
> -- Curt Sampson <cjs(at)cynic(dot)net> wrote:
>> Some of your backends are getting pretty darn big. I wonder what
>> they're doing? It can't be sort memory at this point. But as you
>> can see, those five 200-250MB backends are killing you.

> no, not really: they use shared memory:

No, because all the backends will be accessing the *exact same* shared
memory; it's impossible for some to be using more than others. Since we
see process sizes ranging from 17M to 251M, it's a pretty safe bet that
the latter guys are actually chewing a lot of private space. I don't
know what the "share" column means in that ps display, but I wouldn't
trust it.

regards, tom lane