On Thu, Jun 6, 2013 at 1:44 AM, itishree sukla itishree.su...@gmail.comwrote:
Can any one give more input, you can see my top out put, in %MEM its
taking 24.1.
On Thu, May 30, 2013 at 6:15 PM, itishree sukla
itishree.su...@gmail.comwrote:
Thanks for the quick response. Below is the out put of Top Commnd.
3971 postgres 20 0 8048m 303m 301m S0 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 S0 0.0 1:36.37 postgres:
logger
process
3974 postgres 20 0 8054m 7.6g 7.6g S0 24.1 0:56.59 postgres:
checkpointer
process
3975 postgres 20 0 8051m 895m 891m S0 2.8 0:04.98 postgres:
writer
process
3976 postgres 20 0 8051m 9m 9072 S0 0.0 0:35.17 postgres:
wal writer
process
3977 postgres 20 0 70932 3352 716 S0 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
hlinnakan...@vmware.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
As said before, the memory you may be not the real memory consumed by
checkpointer process, but it includes the shared memory (which is,
basically, used by all postgres' processes).
Depesz wrote a nice topic on his blog about this subject [1], read it and
try the commands to see the real memory usage by checkpointer (when I say
real, I mean private).
[1] http://www.depesz.com/2012/06/09/how-much-ram-is-postgresql-using/
Regards,
--
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres