[PERFORM] Memory question on win32 systems

On Wed, May 28, 2008 at 7:05 PM, Sabbiolina <sabbiolina@gmail.com> wrote:

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.

How are you measuring this?

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?

Post the settings values you're using and people will be better able
to help you.

-Doug

On Thu, May 29, 2008 at 01:05:22AM +0200, Sabbiolina wrote:

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?

PG relies on the operating system to cache most disk accesses. Looking
at the amount of memory a process directly uses isn't a good measure of
this, a better method would be to watch what the IO subsystem is doing.
If you've got lots of reads happening then the disk isn't being cached.

Sam