Re: Version 7 question

On Tue, 1 Jul 2003 15:02:21 +0200, "Michael Mattox"
<michael.mattox@verideon.com> wrote:
>I have 1.5 gigs of RAM on my
>server but I'm also running a few other java programs that take up probably
>500 megs total of memory, leaving me 1gig for Postgres.  Should I set my
>shared buffers to be 25% of 1gig?  That would be 32768.  Then what should my
>effective cache be?  Right now I have it set to 64000 which would be
>512megs.  Between the buffers and cache that'd be a total of 768megs,
>leaving approximately 768 for my other java apps & the OS.

Michael, by setting effective_cache_size you do not allocate anything.
This configuration variable is just a *hint* to the planner how much
RAM is used for caching on your system (as shown by top or free).

Servus
 Manfred