Re: PostgreSQL Database performance

From: "Ilya Kazakevich" <Ilya(dot)Kazakevich(at)JetBrains(dot)com>
To: "'Pradeep'" <pgundala(at)avineonindia(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL Database performance
Date: 2016-09-06 17:52:13
Message-ID: 00df01d20867$66a8fc10$33faf430$@JetBrains.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2016-09-06 17:52:41 Re: Privileges on public schema can't be revoked?
Previous Message Naveed Shaikh 2016-09-06 17:51:57 Re: PostgreSQL Database performance