Re: PostgreSQL Database performance

["Ilya Kazakevich" <Ilya.Kazakevich@xxxxxxxxxxxxx>]

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

The Drive to Develop

 

From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Pradeep
Sent: Saturday, September 03, 2016 6:39 AM
To: pgsql-general@xxxxxxxxxxxxxx
Subject: PostgreSQL Database performance