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.33971 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
On Thu, May 30, 2013 at 5:56 PM, Heikki Linnakangas <hlinnakangas@xxxxxxxxxx> wrote:
On 30.05.2013 15:09, itishree sukla wrote: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.
In our server Check pointer process is consuming 8 GB of memory, what could
be the possible reason? Can any one please help.
- Heikki
