On Wed, 2007-10-10 at 19:49 -0500, Scott Marlowe wrote: > On 10/10/07, Radhika S <[EMAIL PROTECTED]> wrote: > > Thank you scott. > > > > We plan on upgrading to Postgres 8.2 very soon. > > Would it be safe to say I can make my SHARED BUFFER setting 200MB (I have > > 2GB memory ). > > The default is 24MB. > > On a dedicated db machine with 2 Gigs of ram 500Meg is fine. I run > 768 Meg shared_buffers on a machine that runs postgresql 8.2 and > apache/php and routinely have 1Gig of kernel cache on it. > > So yeah, 200M shared_buffers should be no problem.
I have 768MB of ram and I'm allocatting 300MB as shared buffers. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match