From: | "Michael Mattox" <michael(dot)mattox(at)verideon(dot)com> |
---|---|
To: | "Robert Treat" <xzilla(at)users(dot)sourceforge(dot)net> |
Cc: | <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Version 7 question |
Date: | 2003-07-01 13:02:21 |
Message-ID: | CJEBLDCHAADCLAGIGCOOKEOKCKAA.michael.mattox@verideon.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Howard Oblowitz | 2003-07-01 13:06:04 | FW: Version 7 question |
Previous Message | scott.marlowe | 2003-07-01 12:55:55 | Re: Version 7 question |