Postgres Pro
Downloads
Home   >   mailing lists

Advise on memory usage limitation by PostgreSQL on Windows - Mailing list pgsql-general

From Venkata Balaji N
Subject Advise on memory usage limitation by PostgreSQL on Windows
Date
Msg-id CAEyp7J8Ky3hL1mUksBYUYEu_H32WwY8yTD+XXZZV117L4CvtAQ@mail.gmail.com
Whole thread Raw
Responses Re: Advise on memory usage limitation by PostgreSQL on Windows
List pgsql-general
Tree view
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 by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Inject rows into query resultes
Next
From: Jeff Dik
Date:
Subject: The curious case of two inserts, a shrinking xmax, and a ShareLock on transaction