Re: PostgreSQL Database performance
| От | Naveed Shaikh |
|---|---|
| Тема | Re: PostgreSQL Database performance |
| Дата | |
| Msg-id | CAC50kKi-thzCnROwt+Uh=BDP1JHX4T4+HB1cvc8V_3UD1HCpPw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: PostgreSQL Database performance ("Ilya Kazakevich" <Ilya.Kazakevich@JetBrains.com>) |
| Список | pgsql-general |
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
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 по дате отправления: