> 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 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match