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.kazakev...@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-ow...@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 >
