"Anibal David Acosta" wrote: >> The general guidelines for Windows servers such as >> http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server >> recommend a fairly small setting for the shared_buffers parameters >> on Windows--no more than 512MB. > Even if I have a server with 16GB of ram, I must set the > shared_buffer to 512MB on windows? > > In the wiki page they talk about 1/4 of ram, in my case that > represent a shared_buffer = 4GB, that is incorrect? There's an effective maximum, depending on the platform. On Linux that seems to be somewhere in the 8GB to 10GB. On Windows it is much less. > If I can't configure more than 512MB of shared_buffer all other RAM > is unnecessary? The RAM not used for other purposes is used by the OS for caching. PostgreSQL goes through that cache, so the extra memory will be used; it's a question of what balance between PostgreSQL buffers and OS cache gives the best performance. -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
