Обсуждение: Check Pointer

On 5/30/13 8:09 AM, 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.

That process will eventually access all of shared_buffers, which shows
as a shared memory block for that process.  That's what you're seeing
there.  It doesn't actually use any significant amount of memory on its own.

--
Greg Smith   2ndQuadrant US    greg@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.com

On 30.05.2013 15:09, 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.

- Heikki

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  20   0 8048m 303m 301m S    0  0.9   0:04.34 3971 postgres  20   0 8048m 303m 301m S    0  0.9  
0:04.34/usr/lib/postgresql/9.2/bin/postgres -D /var/lib/postgresql/9.2/main -c config_file=/etc/postgre 
>> 3972 postgres  20   0 66828 1820  708 S    0  0.0   1:36.37 postgres: logger process
>> 3974 postgres  20   0 8054m 7.6g 7.6g S    0 24.1   0:56.59 postgres: checkpointer process
>> 3975 postgres  20   0 8051m 895m 891m S    0  2.8   0:04.98 postgres: writer process
>> 3976 postgres  20   0 8051m   9m 9072 S    0  0.0   0:35.17 postgres: wal writer process
>> 3977 postgres  20   0 70932 3352  716 S    0  0.0   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.  It's referencing all of your shared_buffers.

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

--On 30. Mai 2013 18:15:04 +0530 itishree sukla <itishree.sukla@gmail.com>
wrote:

> Thanks for the quick response. Below is the out put of Top Commnd.
>
> 3971 postgres  20   0 8048m 303m 301m S    0  0.9   0:04.34
> /usr/lib/postgresql/9.2/bin/postgres -D /var/lib/postgresql/9.2/main -c
> config_file=/etc/postgre
>  3972 postgres  20   0 66828 1820  708 S    0  0.0   1:36.37
> postgres: logger
> process                                 
>
                                    >
 
>  3974 postgres  20   0 8054m 7.6g 7.6g S    0 24.1   0:56.59
> postgres: checkpointer
> process                                 
>                                 

On Linux i often find the pmap utility a far better tool to get an idea
what a process
actually consumes of memory. The output can be large sometimes, but it's
more "fine grained".


--
Thanks

    Bernd