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

 

 

 

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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Privileges on public schema can't be revoked?
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: Help with slow query - Pgsql 9.2