Re: Version 7 question - Mailing list pgsql-performance

From Michael Mattox
Subject Re: Version 7 question
Date
Msg-id CJEBLDCHAADCLAGIGCOOKEOKCKAA.michael.mattox@verideon.com
Whole thread Raw
In response to Re: Version 7 question  (Robert Treat <xzilla@users.sourceforge.net>)
Responses Re: Version 7 question  (Manfred Koizar <mkoi-pg@aon.at>)
List pgsql-performance
> yes, I'd say start with about 25% of RAM, then adjust from there. If 25%
> takes you over your SHMMAX then start at your SHMMAX.

You're the first person I've seen to suggest that many buffers.  I've read
that too many can slow down performance.  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.

Sounds reasonable to me.

Michael




pgsql-performance by date:

Previous
From: Robert Treat
Date:
Subject: Re: Version 7 question
Next
From: "scott.marlowe"
Date:
Subject: Re: Version 7 question