Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL Database performance - Mailing list pgsql-general

From Ilya Kazakevich
Subject Re: PostgreSQL Database performance
Date
Msg-id 00df01d20867$66a8fc10$33faf430$@JetBrains.com
Whole thread Raw
In response to PostgreSQL Database performance  ("Pradeep" <pgundala@avineonindia.com>)
Responses Re: PostgreSQL Database performance
List pgsql-general
Tree view

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@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Pradeep
Sent: Saturday, September 03, 2016 6:39 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] PostgreSQL Database performance

pgsql-general by date:

Previous
From: Naveed Shaikh
Date:
Subject: Re: PostgreSQL Database performance
Next
From: Stephen Frost
Date:
Subject: Re: Privileges on public schema can't be revoked?