Re: need help on memory allocation

Am 23.01.2018 um 14:59 schrieb Rambabu V:
>              total       used       free     shared buffers     cached
> Mem:           58G        58G       358M        16G  3.6M        41G
> -/+ buffers/cache:        16G        42G
> Swap:         9.5G       687M       8.9G
>
> *postgresql.conf parametes:*
> *=====================*
> work_mem = 256MB# min 64kB
> maintenance_work_mem = 256MB# min 1MB
> shared_buffers = 16GB# min 128kB
> temp_buffers = 16MB# min 800kB
> wal_buffers = 64MB
> effective_cache_size = 64GB
> max_connections = 600
>

how many active concurrent connections do you have? With work_mem = 
256MB and 600 active connections and only 1 allocation of work_mem per 
connection you will need more than 150GB of RAM.


With other words: you should lowering work_mem and/or max_connections.


Regards, Andreas

-- 
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com