Re: Process - Mailing list pgsql-admin

From Tom Lane
Subject Re: Process
Date
Msg-id 25797.1176215795@sss.pgh.pa.us
Whole thread Raw
In response to Process  ("Alexander B." <burbello3000@yahoo.com.br>)
List pgsql-admin
"Alexander B." <burbello3000@yahoo.com.br> writes:
> I have a Postgres server that has more than 500MB ( shared_buffers =
> 64000) and looking at TOP command, I couldn't understand why appears
> some process with 536m and other with 23m.
> What's the difference between?

Some versions of top only count the pages of shared memory that a
given process has actually touched so far.  So for example in the
shared buffer arena, the reported usage will rise as the process runs
longer and chances to use buffers other than the ones it's used already.
It's pretty misleading, because it makes normal behavior look like a
memory leak :-(

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problems with precompiled pgsql on mac
Next
From: "Aaron Bono"
Date:
Subject: Re: [pgadmin-support] Motivations for PostgreSQL