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
This is a multi-part message in MIME format. --------------080704000904040802050609 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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! --------------080704000904040802050609--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?42F25526.5030002>