X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 653723A4BCE for ; Fri, 29 Oct 2004 15:02:23 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 39814-05 for ; Fri, 29 Oct 2004 14:02:15 +0000 (GMT) Received: from sccrmhc12.comcast.net (sccrmhc12.comcast.net [204.127.202.56]) by svr1.postgresql.org (Postfix) with ESMTP id 133293A4BCB for ; Fri, 29 Oct 2004 15:02:18 +0100 (BST) Received: from [127.0.0.1] (c-67-160-247-54.client.comcast.net[67.160.247.54]) by comcast.net (sccrmhc12) with ESMTP id <20041029140217012009laume> (Authid: pathat); Fri, 29 Oct 2004 14:02:18 +0000 Message-ID: <41824E05.8000903@comcast.net> Date: Fri, 29 Oct 2004 07:04:53 -0700 From: Patrick Hatcher User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: determining max_fsm_pages Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/468 X-Sequence-Number: 8944 Pg: 7.4.5 8G ram 200G RAID5 I have my fsm set as such: max_fsm_pages = 300000 # min max_fsm_relations*16, 6 bytes each max_fsm_relations = 500 # min 100, ~50 bytes each I just did a vacuum full on one table and saw this result: INFO: analyzing "cdm.cdm_fed_agg_purch" INFO: "cdm_fed_agg_purch": 667815 pages, 3000 rows sampled, 52089570 estimated total rows My question is this: I have about 8 databases running on this server. When I do a vacuum full on each of these databases, there is a INFO section that I assume is the total pages used for that database. Should add ALL these individual pages together and pad the total and use this as my new max_fsm_pages? Should I do the same thing with max_fsm_relations? TIA Patrick