Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 3181764FD9B; Wed, 12 Nov 2008 13:41:14 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 68229-02; Wed, 12 Nov 2008 13:41:09 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from ptb-relay01.plus.net (ptb-relay01.plus.net [212.159.14.145]) by mail.postgresql.org (Postfix) with ESMTP id 8930C64FCE9; Wed, 12 Nov 2008 13:41:09 -0400 (AST) Received: from [84.51.143.99] (helo=server3.office.archonet.com) by ptb-relay01.plus.net with esmtp (Exim) id 1L0JiE-0005Ny-Ss; Wed, 12 Nov 2008 17:41:07 +0000 Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id A708527406A; Wed, 12 Nov 2008 17:41:06 +0000 (GMT) Message-ID: <491B1532.10605@archonet.com> Date: Wed, 12 Nov 2008 17:41:06 +0000 From: Richard Huxton User-Agent: Thunderbird 2.0.0.17 (X11/20080914) MIME-Version: 1.0 To: paulo matadr CC: GENERAL , admin Subject: Re: [GENERAL] MAX_CONNECTIONS ?? References: <234747.33153.qm@web52501.mail.re2.yahoo.com> In-Reply-To: <234747.33153.qm@web52501.mail.re2.yahoo.com> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Plusnet-Relay: 9fd944a6de4823fc6728f10603bf807b X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200811/65 X-Sequence-Number: 30719 paulo matadr wrote: > I need help to alter max_connections em my database, this parameter > stay in defalt MAX_CONNECTIONS=100 > I want to change for MAX_CONNECTIONS=300. about parameters below, > need to change anything? > > 1 -sysctl.conf > > kernel.shmmax = 68719476736 > kernel.shmall = 4294967296 Does your shmmax have one digit too many? 68GB? > # - Memory - > > 2-Postgresql.conf > shared_buffers = 2048MB > temp_buffers = 12MB > work_mem = 12MB > maintenance_work_mem = 128MB > max_fsm_pages = 4000000 > max_fsm_relations = 5000 Should be OK, depending on your work-load. One question - what do you plan on doing with 300 active connections? Unless you've got more than 100 processors in this machine you might want to consider connection-pooling. -- Richard Huxton Archonet Ltd