X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 58A5E475C85 for ; Mon, 24 Feb 2003 13:55:25 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 36423-01 for ; Mon, 24 Feb 2003 13:55:14 -0500 (EST) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by postgresql.org (Postfix) with ESMTP id 7C2DA475D0D for ; Mon, 24 Feb 2003 13:28:52 -0500 (EST) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 2854946 for pgsql-performance@postgresql.org; Mon, 24 Feb 2003 10:28:51 -0800 Content-Type: text/plain; charset="us-ascii" From: Josh Berkus Organization: Aglio Database Solutions To: pgsql-performance@postgresql.org Subject: Memory taken by FSM_relations Date: Mon, 24 Feb 2003 10:28:00 -0800 User-Agent: KMail/1.4.3 MIME-Version: 1.0 Message-Id: <200302241028.00309.josh@agliodbs.com> Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/179 X-Sequence-Number: 1235 Folks: I'm not clear on where the memory needed by max_fsm_pages comes from. Is = it=20 taken out of the shared_buffers, or in addition to them? Further, Joe Conway gave me a guesstimate of 6k per max_fsm_pages which see= ms=20 rather high ... in fact, the default settings for this value (10000) would= =20 swamp the memory used by the rest of Postgres. Does anyone have a good=20 measurment of the memory load imposed by higher FSM settings? --=20 Josh Berkus Aglio Database Solutions San Francisco