Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL Database performance - Mailing list pgsql-general

From Naveed Shaikh
Subject Re: PostgreSQL Database performance
Date
Msg-id CAC50kKi-thzCnROwt+Uh=BDP1JHX4T4+HB1cvc8V_3UD1HCpPw@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL Database performance  ("Ilya Kazakevich" <Ilya.Kazakevich@JetBrains.com>)
List pgsql-general
Tree view
On Windows, large values for shared_buffers aren't as effective. You may find better results keeping the setting relatively low and using the operating system cache more instead. The useful range for shared_buffers on Windows systems is generally from 64MB to 512MB.

---
Warm Regards,
----------
Naveed Shaikh

On Tue, Sep 6, 2016 at 11:22 PM, Ilya Kazakevich <Ilya.Kazakevich@jetbrains.com> wrote:

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: Tom Lane
Date:
Subject: Re: Privileges on public schema can't be revoked?
Next
From: Jeff Janes
Date:
Subject: Re: Help with slow query - Pgsql 9.2