Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Ukru4-0000m4-6M for pgsql-performance@arkaria.postgresql.org; Fri, 07 Jun 2013 08:20:08 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Ukru3-0005hH-MD for pgsql-performance@arkaria.postgresql.org; Fri, 07 Jun 2013 08:20:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Ukru1-0005gC-HZ for pgsql-performance@postgresql.org; Fri, 07 Jun 2013 08:20:05 +0000 Received: from dd2030.kasserver.com ([85.13.128.37]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Ukrtw-0006lo-Mk for pgsql-performance@postgresql.org; Fri, 07 Jun 2013 08:20:05 +0000 Received: from [172.26.14.123] (exit.credativ.com [87.139.82.80]) by dd2030.kasserver.com (Postfix) with ESMTPSA id AF49BE013A; Fri, 7 Jun 2013 10:19:58 +0200 (CEST) Date: Fri, 07 Jun 2013 10:19:58 +0200 From: Bernd Helmle To: itishree sukla , Heikki Linnakangas cc: pgsql-performance@postgresql.org Subject: Re: Check Pointer Message-ID: <01DB5926A90B9B3C23626456@apophis.local> In-Reply-To: References: <51A7457F.3040309@vmware.com> X-Mailer: Mulberry/4.1.0a3 (Mac OS X) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline; size=1025 X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org --On 30. Mai 2013 18:15:04 +0530 itishree sukla = =20 wrote: > Thanks for the quick response. Below is the out put of Top Commnd. > > 3971 postgres=C2=A0 20=C2=A0=C2=A0 0 8048m 303m 301m S=C2=A0=C2=A0=C2=A0 = 0=C2=A0 0.9=C2=A0=C2=A0 0:04.34 > /usr/lib/postgresql/9.2/bin/postgres -D /var/lib/postgresql/9.2/main -c > config_file=3D/etc/postgre > =C2=A03972 postgres=C2=A0 20=C2=A0=C2=A0 0 66828 1820=C2=A0 708 S=C2=A0= =C2=A0=C2=A0 0=C2=A0 0.0=C2=A0=C2=A0 1:36.37 > postgres: logger > process=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 >=20 =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=8D>= =20 =C2=A0 > =C2=A03974 postgres=C2=A0 20=C2=A0=C2=A0 0 8054m 7.6g 7.6g S=C2=A0=C2=A0= =C2=A0 0 24.1=C2=A0=C2=A0 0:56.59 > postgres: checkpointer > process=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 On Linux i often find the pmap utility a far better tool to get an idea=20 what a process actually consumes of memory. The output can be large sometimes, but it's=20 more "fine grained". --=20 Thanks Bernd --=20 Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance