DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=ymail.com;
	h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=m7O6L90IHb5DUgyrXmYxeAYorxzWKS/aS03waezu6XrOv3THUWvzbtPBgPLQ9c++PwcgQf9Xsxq0cqQLCTALqM91R9bmTddyxUShCp7+m1X2BvzjYnKafK26QeFVzkpsqvhmADL4u5A8xGONvvupd9ODyHqIw6tkCuHZPbBexQI=;
References: 
 <CAL-g6VSk__SYiEUyHaSGgkF7GWy5EHSnZSDfxqD45=0oUqSbCA@mail.gmail.com>
	<51A7457F.3040309@vmware.com>
	<CAL-g6VRhxV=0SQoTSotmr6qzW_-sUd=ynjJzyFqdUxcEbafVnw@mail.gmail.com>
	<CAL-g6VSMxykooTv5vmCZAWwCn9SgVYRcPRHUEtVAdrNFgvR8jg@mail.gmail.com>
Message-ID: <1370523198.13282.YahooMailNeo@web162903.mail.bf1.yahoo.com>
Date: Thu, 6 Jun 2013 05:53:18 -0700 (PDT)
From: Kevin Grittner <kgrittn@ymail.com>
Reply-To: Kevin Grittner <kgrittn@ymail.com>
Subject: Re: Check Pointer
To: itishree sukla <itishree.sukla@gmail.com>,
	Heikki Linnakangas <hlinnakangas@vmware.com>
Cc: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
In-Reply-To: 
 <CAL-g6VSMxykooTv5vmCZAWwCn9SgVYRcPRHUEtVAdrNFgvR8jg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

itishree sukla <itishree.sukla@gmail.com> wrote:
> itishree sukla <itishree.sukla@gmail.com> wrote:
>> Heikki Linnakangas <hlinnakangas@vmware.com> wrote:
>>> itishree sukla wrote:
>>>
>>>> In our server Check pointer process is consuming 8 GB of
>>>> memory, what could be the possible reason? Can any one please
>>>> help.
>>>
>>> Are you sure you're measuring the memory correctly? The RES
>>> field in top output, for example, includes shared memory, ie.
>>> the whole buffer cache. Shared memory isn't really "consumed"
>>> by the checkpointer process, but shared by all postgres processes.
>>
>> Thanks for the quick response. Below is the out put of Top
>> Commnd.
>>
>> 3971 postgres=A0 20=A0=A0 0 8048m 303m 301m S=A0=A0=A0 0=A0 0.9=A0=A0 0:=
04.34 3971 postgres=A0 20=A0=A0 0 8048m 303m 301m S=A0=A0=A0 0=A0 0.9=A0=A0=
 0:04.34 /usr/lib/postgresql/9.2/bin/postgres -D /var/lib/postgresql/9.2/ma=
in -c config_file=3D/etc/postgre
>> 3972 postgres=A0 20=A0=A0 0 66828 1820=A0 708 S=A0=A0=A0 0=A0 0.0=A0=A0 =
1:36.37 postgres: logger process
>> 3974 postgres=A0 20=A0=A0 0 8054m 7.6g 7.6g S=A0=A0=A0 0 24.1=A0=A0 0:56=
.59 postgres: checkpointer process
>> 3975 postgres=A0 20=A0=A0 0 8051m 895m 891m S=A0=A0=A0 0=A0 2.8=A0=A0 0:=
04.98 postgres: writer process
>> 3976 postgres=A0 20=A0=A0 0 8051m=A0=A0 9m 9072 S=A0=A0=A0 0=A0 0.0=A0=
=A0 0:35.17 postgres: wal writer process
>> 3977 postgres=A0 20=A0=A0 0 70932 3352=A0 716 S=A0=A0=A0 0=A0 0.0=A0=A0 =
0:05.19 postgres: stats collector process

> Can any one give more input, you can see my top out put, in %MEM
> its taking 24.1.

It's not.=A0 It's referencing all of your shared_buffers.

--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


--=20
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance