itishree sukla <itishree.sukla@xxxxxxxxx> wrote: > itishree sukla <itishree.sukla@xxxxxxxxx> wrote: >> Heikki Linnakangas <hlinnakangas@xxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
