Hi.
"shared_buffers" should be set to 30-40% of your system RAM.
This param controls how much memory database may use.
Please see
https://www.postgresql.org/docs/9.1/static/runtime-config-resource.html
Ilya Kazakevich
JetBrains
<http://www.jetbrains.com/> http://www.jetbrains.com
The Drive to Develop
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Pradeep
Sent: Saturday, September 03, 2016 6:39 AM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] PostgreSQL Database performance