X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E11EB475ED4 for ; Mon, 24 Feb 2003 16:33:12 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 79544-06 for ; Mon, 24 Feb 2003 16:32:44 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 1A620475AD4 for ; Mon, 24 Feb 2003 15:17:41 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h1OKHe5u005222; Mon, 24 Feb 2003 15:17:40 -0500 (EST) To: Josh Berkus Cc: pgsql-performance@postgresql.org Subject: Re: Memory taken by FSM_relations In-reply-to: <200302241028.00309.josh@agliodbs.com> References: <200302241028.00309.josh@agliodbs.com> Comments: In-reply-to Josh Berkus message dated "Mon, 24 Feb 2003 10:28:00 -0800" Date: Mon, 24 Feb 2003 15:17:40 -0500 Message-ID: <5221.1046117860@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/191 X-Sequence-Number: 1247 Josh Berkus writes: > I'm not clear on where the memory needed by max_fsm_pages comes from. > Is it taken out of the shared_buffers, or in addition to them? In addition to. Basically max_fsm_pages and max_fsm_relations are used to ratchet up the postmaster's initial shared memory request to the kernel. > Further, Joe Conway gave me a guesstimate of 6k per max_fsm_pages > which seems rather high ... Quite ;-). The correct figure is six bytes per fsm_page slot, and I think about forty bytes per fsm_relation slot (recent versions of postgresql.conf mention the multipliers, although for some reason the Admin Guide does not). regards, tom lane