From: | itishree sukla <itishree(dot)sukla(at)gmail(dot)com> |
---|---|
To: | Heikki Linnakangas <hlinnakangas(at)vmware(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Check Pointer |
Date: | 2013-06-06 04:44:14 |
Message-ID: | CAL-g6VSMxykooTv5vmCZAWwCn9SgVYRcPRHUEtVAdrNFgvR8jg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Can any one give more input, you can see my top out put, in %MEM its taking
24.1.
Regards,
Itishree
On Thu, May 30, 2013 at 6:15 PM, itishree sukla <itishree(dot)sukla(at)gmail(dot)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
> 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
> 1
>
> Postgresql =9.2.3
>
>
>
> On Thu, May 30, 2013 at 5:56 PM, Heikki Linnakangas <
> hlinnakangas(at)vmware(dot)com> wrote:
>
>> 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
>>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ghislain ROUVIGNAC | 2013-06-06 08:25:31 | Not same plan between static and prepared query |
Previous Message | Emrah Mehmedov | 2013-06-05 11:15:43 | Re: PHP Postgres query slower then PgAdmin |