Skip site navigation (1) Skip section navigation (2)

Re: Setting bigger OS cache on Windows server

From: "Lukas" <Lukas(at)fmf(dot)vtu(dot)lt>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Setting bigger OS cache on Windows server
Date: 2011-12-05 22:57:55
Message-ID: ea3dbecec1be1d14f53427b3d17d1fee.squirrel@fmf.vtu.lt (view raw or flat)
Thread:
Lists: pgsql-novice
Hello,

 well, according the document it is not like that:
"It's likely you will have to increase the amount of memory your operating
system allows you to allocate at once..."
 I understand it as I need to set that value somewhere in OS..?
 I have problem, that our database is big, server has 4GB of ram, and
about 70% of ram is free... At the same time I have some 20-30 busy
connections to Postgres, and it works slow... For me seems like tunable
problem..?


Lukas


> On Mon, Dec 05, 2011 at 10:24:17PM +0200, Lukas wrote:
>> Hello,
>>
>> I found such note in wiki of Postgresql
>> (http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server ):
>> Note that on Windows (and on PostgreSQL versions before 8.1), large
>> values
>> for shared_buffers aren't as effective, and you may find better results
>> keeping it relatively low and using the OS cache more instead.
>>
>> Can anyone tell how OS cache should be increased on windows server?
>>
>>
>> thx
>> Lukas
>>
>
> I think that like Linux it is not a tunable setting. The OS will us
> as much memory as it can while still meeting the memory resource needs
> of the applications running on the machine. The upshot is -- buy more
> memory. The take-away from the above doc quote is to drop the amount
> of shared_buffers for PostgreSQL, since you can control that.
>
> Cheers,
> Ken
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>



In response to

pgsql-novice by date

Next:From: Pandu PoluanDate: 2011-12-06 07:57:43
Subject: How to add description for databases and tables?
Previous:From: Merlin MoncureDate: 2011-12-05 21:13:47
Subject: Re: Linux server connection process consumes all memory

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group