Postgres consumes a lot of RAM (cached)

1 vote

2 answers

13808 views

                          I have a small database PostgreSQL (v9.3) on Centos 6 x64 ( RAM: 8 GB ).

**postgresql.conf**

    max_connections = 512
    shared_buffers = 3000MB	 
    temp_buffers = 8MB			
    work_mem = 2MB			
    maintenance_work_mem = 128MB		 
    effective_cache_size = 3000MB

About 150 connections, PostgreSQL takes more than 6 GB of RAM (of course, other applications use about 200 MB of RAM), here my info:

    Mem:  7062.945M total, 6892.410M used,  170.535M free, 6644.000k buffers
    Swap:    0.000k total,    0.000k used,    0.000k free, 5378.922M cached

###Questions:

1. Why does PG takes a lot of RAM ? 

2. How can I reduce cached buffers of PG ?

Asked by Luan Huynh (2010 rep)

Oct 6, 2015, 02:31 AM
Last activity: Jun 18, 2018, 05:39 PM

Postgres consumes a lot of RAM (cached)

Related Questions