Advise on memory usage limitation by PostgreSQL on Windows

From: Venkata Balaji N <nag1010(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Advise on memory usage limitation by PostgreSQL on Windows
Date: 2015-09-23 01:33:17
Message-ID: CAEyp7J8Ky3hL1mUksBYUYEu_H32WwY8yTD+XXZZV117L4CvtAQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Dik 2015-09-23 02:31:04 The curious case of two inserts, a shrinking xmax, and a ShareLock on transaction
Previous Message David G. Johnston 2015-09-22 23:05:30 Re: Inject rows into query resultes