Re: [PERFORM] Check Pointer

2013-06-07 Thread Matheus de Oliveira
On Thu, Jun 6, 2013 at 1:44 AM, itishree sukla wrote: > 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 > wrote: > >> Thanks for the quick response. Below is the out put of Top Commnd. >> >> 3971 postgres 2

Re: [PERFORM] Check Pointer

2013-06-07 Thread Bernd Helmle
--On 30. Mai 2013 18:15:04 +0530 itishree sukla 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 postg

Re: [PERFORM] Check Pointer

2013-06-06 Thread Kevin Grittner
itishree sukla wrote: > itishree sukla wrote: >> Heikki Linnakangas 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 co

Re: [PERFORM] Check Pointer

2013-06-05 Thread itishree sukla
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 wrote: > 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/

Re: [PERFORM] Check Pointer

2013-05-30 Thread itishree sukla
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: log

Re: [PERFORM] Check Pointer

2013-05-30 Thread Heikki Linnakangas
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

Re: [PERFORM] Check Pointer

2013-05-30 Thread Dinesh Kumar
Hi , Could you share the command, what you have used to confirm that, the checkpoint process is consuming 8GB. And also, please share the addition information like PostgreSQL version and the OS details. I am suspecting that, your shared_buffers value is 8GB, and the "top" command is showing the u

Re: [PERFORM] Check Pointer

2013-05-30 Thread Greg Smith
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

[PERFORM] Check Pointer

2013-05-30 Thread itishree sukla
Hi all, In our server Check pointer process is consuming 8 GB of memory, what could be the possible reason? Can any one please help. Regards, Itishree