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.

Reply via email to