Re: need help on memory allocation

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





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





[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux