Re: [PERFORM] Memory question on win32 systems - Mailing list pgsql-hackers

From Douglas McNaught
Subject Re: [PERFORM] Memory question on win32 systems
Date
Msg-id 5ded07e00805281711t6509bd8csf5f36609c064c5d5@mail.gmail.com
Whole thread Raw
In response to [PERFORM] Memory question on win32 systems  (Sabbiolina <sabbiolina@gmail.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Re: intercepting WAL writes
Next
From: Jeff Davis
Date:
Subject: Re: intercepting WAL writes