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 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 |
