Advise on memory usage limitation by PostgreSQL on Windows

Поиск
Список
Период
Сортировка
От Venkata Balaji N
Тема Advise on memory usage limitation by PostgreSQL on Windows
Дата
Msg-id CAEyp7J8Ky3hL1mUksBYUYEu_H32WwY8yTD+XXZZV117L4CvtAQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Advise on memory usage limitation by PostgreSQL on Windows
Список pgsql-general
Дерево обсуждения
Hello,

We would like to know if there is any limitation around memory utilization by PostgreSQL on Windows systems.

As of now, we do not have the details about the exact Windows version in use.

Windows server is with 5 GB RAM and 4 CPUs (4 cores). PostgreSQL Version is 9.1.x which will possibly be upgraded to 9.4.x.

After a detailed analysis on memory usage by OS and other processes, is it safe to advise on configuring shared_buffers to 2 GB ?

Any advise will be appreciated.

Regards,
Venkata Balaji N

Fujitsu Australia

В списке pgsql-general по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Inject rows into query resultes
Следующее
От: Jeff Dik
Дата:
Сообщение: The curious case of two inserts, a shrinking xmax, and a ShareLock on transaction