Search Postgresql Archives

Re: Advise on memory usage limitation by PostgreSQL on Windows

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Venkata Balaji N
Sent: September-22-15 21:33
To: pgsql-general
Subject: 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux