Date: Thu, 04 Aug 2005 13:49:26 -0400 From: Bruce Walker <bmw@borderware.com> To: Sean Chittenden <sean@gigave.com> Cc: freebsd-performance@freebsd.org Subject: Re: changing max_connections in postgresql on FreeBSD 5.4 Message-ID: <42F25526.5030002@borderware.com> In-Reply-To: <20050804174508.GA70123@sean.gigave.com> References: <b41c755205080410013348d0f@mail.gmail.com> <20050804174508.GA70123@sean.gigave.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Sean Chittenden wrote: >>Will more RAM become available to postgresql if I change the >>kernel-values mentioned above to half the size? >> >> > >Yes, it will raise the in-kernel limits so that PostgreSQL can >allocate more RAM for its user-land cache. > >You will probably have a better ROI in terms of performance by >increasing the kernel's caching parameters as opposed to PostgreSQL's >cache. You need both, don't get me wrong, but there is lots of >performance to be gained by increasing the amount of caching the >kernel does. -sc > > Any generally good rules of thumb you could share? Which kernel caching are you referring to (ie disk, ...) ? Thanks!
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?42F25526.5030002>