Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id AE2469FBB53 for ; Wed, 23 May 2007 14:53:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 16914-04 for ; Wed, 23 May 2007 14:53:41 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from h07.llord.com (unknown [195.140.142.194]) by postgresql.org (Postfix) with ESMTP id 2CD349FBB2B for ; Wed, 23 May 2007 14:53:43 -0300 (ADT) Received: from par69-8-88-161-102-87.fbx.proxad.net ([88.161.102.87] helo=apollo13) by h07.llord.com with esmtpa (Exim 4.63) (envelope-from ) id 1Hqv1j-0006lz-OH; Wed, 23 May 2007 19:53:38 +0200 Date: Wed, 23 May 2007 19:56:11 +0200 To: "Y Sidhu" , pgsql-performance@postgresql.org Subject: Re: max_fsm_pages, shared_buffers and checkpoint_segments From: PFC Content-Type: text/plain; format=flowed; delsp=yes; charset=utf-8 MIME-Version: 1.0 References: Content-Transfer-Encoding: 7bit Message-ID: In-Reply-To: User-Agent: Opera Mail/9.10 (Linux) X-PopBeforeSMTPSenders: junk@peufeu.com, lists@peufeu.com, peufeu@peufeu.com, pfcaillaud@peufeu.com X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - h07.llord.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - peufeu.com X-Source: X-Source-Args: X-Source-Dir: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.724 tagged_above=0 required=5 tests=AWL=0.059, BAYES_05=-1.11, RCVD_IN_NJABL_SPAM=2.775 X-Spam-Level: * X-Archive-Number: 200705/463 X-Sequence-Number: 24853 > When I bring shared_buffers or max_fsm_pages back down, the daemon > starts and all is > normal. Linux has a system setting for the maximum number of shared memory that a process can allocate. When Postgres wants more, Linux says "No." Look in the docs for the setting (sysctl whatsisname). VACUUM VERBOSE will tell you if you need to put more max_fsm_pages or not.