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").