Postgres Pro
Downloads
Home   >   mailing lists

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

From Daniel Begin
Subject Re: Advise on memory usage limitation by PostgreSQL on Windows
Date
Msg-id COL129-DS2638B01BFA2CEACD0BFC794440@phx.gbl
Whole thread Raw
In response to Advise on memory usage limitation by PostgreSQL on Windows  (Venkata Balaji N <nag1010@gmail.com>)
List pgsql-general
Tree view

Venkata ,

Not really an advice but the wiki has specific comments about shared_buffers values in Windows environment. See…

http://www.postgresql.org/docs/current/static/runtime-config-resource.html#GUC-SHARED-BUFFERS

 

I use a Windows 7 64b, 16 GB RAM, 4 cores.  According to the above link I set shared_buffers = 128MB with an effective_cache_size = 12GB

Daniel

 

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Venkata Balaji N
Sent: September-22-15 21:33
To: pgsql-general
Subject: [GENERAL] Advise on memory usage limitation by PostgreSQL on Windows

 

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: Alvaro Herrera
Date:
Subject: Re: The curious case of two inserts, a shrinking xmax, and a ShareLock on transaction
Next
From: Etienne Champetier
Date:
Subject: OR vs UNION vs UNION ALL