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
