Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 5DC1C98FC83 for ; Tue, 8 May 2012 06:29:37 -0300 (ADT) Received: from rs133.luxsci.com ([72.32.115.26]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SRgje-0006xG-An for pgsql-admin@postgresql.org; Tue, 08 May 2012 09:29:36 +0000 Received: from GNANAM (NSG-Static-236.156.72.182.airtel.in [182.72.156.236] (may be forged)) (authenticated bits=0) by rs133.luxsci.com (8.13.8/8.13.8) with ESMTP id q489SJxP002073; Tue, 8 May 2012 04:29:16 -0500 Reply-To: From: "Gnanakumar" To: References: <00da01cd2ce7$35d17780$a1746680$@com> In-Reply-To: <00da01cd2ce7$35d17780$a1746680$@com> Subject: Re: Advice/guideline on increasing shared_buffers and kernel parameters Date: Tue, 8 May 2012 14:56:52 +0530 Organization: Zoniac Software Private Limited Message-ID: <00e101cd2cfc$b6140b00$223c2100$@com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: Ac0s5zMpKYtaWGSyRg+K7Du8nW8t9wAFFgwA Content-Language: en-us X-Lux-Comment: Message q489SJxP002073 sent by user #22393 X-Pg-Spam-Score: -2.6 (--) X-Archive-Number: 201205/36 X-Sequence-Number: 39525 > did you read > http://www.postgresql.org/docs/8.2/static/kernel-resources.html ? Yes, I read. But I'm not able to find a correct way to increase Linux Kernel parameters. > If it is a dedicated DB server the rule of thumb usually is to use > 25% RAM for shared buffers, but no more than 8GB unless proper > benchmarking has shown a benefit using above 8GB. But I am not > sure if 8GB of shared buffers is suitable for 8.2 at all. 8.2 is EOL btw. > Also set effective cache size to 50% RAM. As you can see, in my case, I'm setting only 3 GB (3072 MB), which is actually below 8 GB. So, I need to increase kernel parameters in this case. Any ideas/insights? > Also, do you really NEED 1000 concurrent sessions? IF you really do, it might > be worse to look into a connection pooler. Yes, our web-based application has crossed more than 500 concurrent users. Hence we've already upgraded RAM and now we want to upgrade max connection parameter too. Yes, we're already using pgpool-II v3.1.1 for connection pooling.