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