X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 44D0B475ADD for ; Mon, 24 Feb 2003 15:12:10 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 57278-10 for ; Mon, 24 Feb 2003 15:11:59 -0500 (EST) Received: from lerami.lerctr.org (lerami.lerctr.org [207.158.72.11]) by postgresql.org (Postfix) with ESMTP id D1FA1474E4F for ; Mon, 24 Feb 2003 14:35:46 -0500 (EST) Received: from lerlaptop.iadfw.net (lerlaptop.iadfw.net [206.66.13.21]) (authenticated bits=0) by lerami.lerctr.org (8.12.7/8.12.7/20030220) with ESMTP id h1OJZYGU016457; Mon, 24 Feb 2003 13:35:34 -0600 (CST) Date: Mon, 24 Feb 2003 13:35:34 -0600 From: Larry Rosenman To: Joe Conway , Josh Berkus Cc: pgsql-performance@postgresql.org Subject: Re: Memory taken by FSM_relations Message-ID: <251960000.1046115334@lerlaptop.iadfw.net> In-Reply-To: <3E5A6E66.4030408@joeconway.com> References: <200302241028.00309.josh@agliodbs.com> <3E5A6E66.4030408@joeconway.com> X-Mailer: Mulberry/3.0.1 (Linux/x86) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: by amavisd-milter (http://amavis.org/) X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/187 X-Sequence-Number: 1243 --On Monday, February 24, 2003 11:11:34 -0800 Joe Conway wrote: > Josh Berkus wrote: >> Further, Joe Conway gave me a guesstimate of 6k per max_fsm_pages which >> seems rather high ... in fact, the default settings for this value >> (10000) would swamp the memory used by the rest of Postgres. > > I don't recall (and cannot find in my sent mail) ever making that > guesstimate. Can you provide some context? It may be 6 **BYTES** per max_fsm_pages. > > Joe > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749