Re: PostgreSQL Database performance

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(dot)Kazakevich(at)jetbrains(dot)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(at)postgresql(dot)org [mailto:pgsql-general-owner@
> postgresql.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
>