Skip site navigation (1) Skip section navigation (2)

Re: Process

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Alexander B(dot)" <burbello3000(at)yahoo(dot)com(dot)br>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Process
Date: 2007-04-10 14:36:35
Message-ID: 25797.1176215795@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
"Alexander B." <burbello3000(at)yahoo(dot)com(dot)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

In response to

  • Process at 2007-04-10 13:21:02 from Alexander B.

pgsql-admin by date

Next:From: Aaron BonoDate: 2007-04-10 20:22:14
Subject: Re: [pgadmin-support] Motivations for PostgreSQL
Previous:From: Tom LaneDate: 2007-04-10 14:30:52
Subject: Re: Problems with precompiled pgsql on mac

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group