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@xxxxxxxxxxxxx> 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
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@xxxxxxxxxxxxxx
Subject: PostgreSQL Database performance
