I have installed PostgreSQL 9.4 (open source) version on my CentOS Linux Red Hat 7 production server and kept default parameters which are in postgresql.conf file.So my basic question is, once I start using postgres how much RAM the postgres processes consumes (postgres related processes only).
There are lot of allocations in postgresql.conf file, for example shared_buffers, work_mem...etc.
As per my knowledge, all postgres processes should not consume the RAM more than the value assigned in shared_buffers.Please clarify and let me know if I misunderstand the concept..
--
Thanks, Venkata Prasad
shared_buffers is just the shared memory segment. work_mem & maintenance_work mem are used in addition to shared_buffers and there can be multiples of those values in use at the same time. The PostgreSQL wiki has some good guidance on what the different memory settings mean and how to tune them