X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 82A77474E4F for ; Mon, 24 Feb 2003 14:30:21 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 46278-05 for ; Mon, 24 Feb 2003 14:30:10 -0500 (EST) Received: from joeconway.com (63-210-180-150.skyriver.net [63.210.180.150]) by postgresql.org (Postfix) with ESMTP id CC799475EBC for ; Mon, 24 Feb 2003 14:13:34 -0500 (EST) Received: from [206.19.64.3] (account jconway HELO joeconway.com) by joeconway.com (CommuniGate Pro SMTP 4.0.4) with ESMTP-TLS id 1620683; Mon, 24 Feb 2003 11:49:00 -0800 Message-ID: <3E5A6E66.4030408@joeconway.com> Date: Mon, 24 Feb 2003 11:11:34 -0800 From: Joe Conway User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.2.1) Gecko/20021130 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Josh Berkus Cc: pgsql-performance@postgresql.org Subject: Re: Memory taken by FSM_relations References: <200302241028.00309.josh@agliodbs.com> In-Reply-To: <200302241028.00309.josh@agliodbs.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/185 X-Sequence-Number: 1241 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? Joe