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 BCFD7D1B18A for ; Tue, 27 Jul 2004 04:35:53 -0300 (ADT) 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 51478-09 for ; Tue, 27 Jul 2004 07:35:43 +0000 (GMT) Received: from mailer.elma.loc (mail.elma.fr [213.41.14.138]) by svr1.postgresql.org (Postfix) with ESMTP id 1729DD1B179 for ; Tue, 27 Jul 2004 04:35:37 -0300 (ADT) Received: from mailer.elma.loc (localhost [127.0.0.1]) by localhost (Postfix) with ESMTP id C6C63EC311 for ; Tue, 27 Jul 2004 08:38:20 +0200 (CEST) Received: from zoot.elma.fr (herve.elma.fr [10.0.1.2]) by mailer.elma.loc (Postfix) with ESMTP id A51EFEC304 for ; Tue, 27 Jul 2004 08:38:20 +0200 (CEST) From: =?iso-8859-15?q?Herv=E9_Piedvache?= Organization: Elma =?iso-8859-15?q?Ing=E9nierie?= Informatique To: pgsql-performance@postgresql.org Subject: Little understanding for tuning ... Date: Tue, 27 Jul 2004 09:35:33 +0200 User-Agent: KMail/1.6.2 MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: 8bit Message-Id: <200407270935.33431.herve@elma.fr> 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: 200407/188 X-Sequence-Number: 7579 Dear all, This is my two last line of a vacuum full verbose analyse;. INFO:  free space map: 27 relations, 4336 pages stored; 3232 total pages needed DETAIL:  Allocated FSM size: 2000 relations + 50000000 pages = 293088 kB What are the good parameters to set with those informations : max_fsm_pages = 30000   max_fsm_relations = 100 Any other parameters could be defined with this informations ? Thanks per advance, -- Hervé Piedvache Elma Ingénierie Informatique 6 rue du Faubourg Saint-Honoré F-75008 - Paris - France Pho. 33-144949901 Fax. 33-144949902