Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 44C3B14FB14 for ; Thu, 10 May 2012 21:30:10 -0300 (ADT) Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SSdkF-0001Ro-UB for pgsql-admin@postgresql.org; Fri, 11 May 2012 00:30:09 +0000 Received: from bruce by momjian.us with local (Exim 4.72) (envelope-from ) id 1SSdk0-0003zP-PW; Thu, 10 May 2012 20:29:52 -0400 Date: Thu, 10 May 2012 20:29:52 -0400 From: Bruce Momjian To: Gnanakumar Cc: 'Kevin Grittner' , pgsql-admin@postgresql.org Subject: Re: Advice/guideline on increasing shared_buffers and kernel parameters Message-ID: <20120511002952.GC16880@momjian.us> References: <00da01cd2ce7$35d17780$a1746680$@com> <00e101cd2cfc$b6140b00$223c2100$@com> <4FA8E99B0200002500047A16@gw.wicourts.gov> <001f01cd2dd0$4187f8d0$c497ea70$@com> <4FAA3F740200002500047A73@gw.wicourts.gov> <005401cd2e7c$19fb1480$4df13d80$@com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <005401cd2e7c$19fb1480$4df13d80$@com> User-Agent: Mutt/1.5.20 (2009-06-14) X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201205/57 X-Sequence-Number: 39546 On Thu, May 10, 2012 at 12:41:17PM +0530, Gnanakumar wrote: > > There have been numerous discussions of this on the lists, so you > > can probably find a more in-depth discussion of the topic if you > > search the archives, and this may motivate me to put together a Wiki > > page on the topic, but here's the general concept. > > I was really astonished on seeing a great, nice and detailed explanation on > this topic. I would like to *really appreciate* your effort and patience in > writing down this with your real-time experience. I've already thought of > converting this into a document and keep it handy so that I may want to > refer back whenever I need. > > Thanks once again for that great explanation. Agreed. That was pretty amazing! -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +