Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id BDE4A9FB8BD for ; Tue, 10 Apr 2007 11:37:44 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 96054-01-6 for ; Tue, 10 Apr 2007 11:37:30 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id E6B9F9FB835 for ; Tue, 10 Apr 2007 11:36:36 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l3AEaZbs025798; Tue, 10 Apr 2007 10:36:35 -0400 (EDT) To: "Alexander B." cc: "pgsql-admin@postgresql.org" Subject: Re: Process In-reply-to: <461B8F3E.8010006@yahoo.com.br> References: <461B8F3E.8010006@yahoo.com.br> Comments: In-reply-to "Alexander B." message dated "Tue, 10 Apr 2007 10:21:02 -0300" Date: Tue, 10 Apr 2007 10:36:35 -0400 Message-ID: <25797.1176215795@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/83 X-Sequence-Number: 25147 "Alexander B." 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