Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Hackers > [PERFORM] Memor...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 3 Topic 9439 of 10966
Post > Topic >>

[PERFORM] Memory question on win32 systems

by sabbiolina@[EMAIL PROTECTED] (Sabbiolina) May 29, 2008 at 01:05 AM

------=_Part_25190_30699951.1212015922449
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hello, in my particular case I need to configure Postgres to handle only a
few concurrent connections, but I need it to be blazingly fast, so I need
it
to cache everything possible. I've changed the config file and multiplied
all memory-related values by 10, still Postgres uses only less than 50 Mb
of
my RAM.

I have 4 Gigs of RAM, how do I force Postgres to use a higher part of such
memory in order to cache more indexes, queries and so on?

Thanks!

------=_Part_25190_30699951.1212015922449
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline



<p class="MsoNormal"><span style="" lang="EN-US">Hello, in
my particular case I need to configure Postgres to handle only a few
concurrent
connections, but I need it to be blazingly fast, so I need it to cache
everything possible. I've changed the config file and multiplied all
memory-related values by 10, still Postgres uses only less than 50 Mb of
my
RAM.</span></p>

<p class="MsoNormal"><span style="" lang="EN-US">I have 4
Gigs of RAM, how do I force Postgres to use a higher part of such memory
in
order to cache more indexes, queries and so on?</span></p>

<p class="MsoNormal"><span style="" lang="EN-US">Thanks!</span></p>


------=_Part_25190_30699951.1212015922449--
 




 3 Posts in Topic:
[PERFORM] Memory question on win32 systems
sabbiolina@[EMAIL PROTECT  2008-05-29 01:05:22 
Re: [PERFORM] Memory question on win32 systems
doug@[EMAIL PROTECTED] (  2008-05-28 20:11:30 
Re: [PERFORM] Memory question on win32 systems
sam@[EMAIL PROTECTED] (S  2008-05-29 14:45:32 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 14:21:30 CST 2008.