Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 143E29FB201 for ; Sun, 1 Apr 2007 10:59:42 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 19240-06 for ; Sun, 1 Apr 2007 10:59:32 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from web57102.mail.re3.yahoo.com (web57102.mail.re3.yahoo.com [216.252.111.115]) by postgresql.org (Postfix) with SMTP id 0F74A9FA170 for ; Sun, 1 Apr 2007 10:59:37 -0300 (ADT) Received: (qmail 89157 invoked by uid 60001); 1 Apr 2007 13:59:36 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=amThOe9CoCEXIfTBHbgrQ9Pz3bf3uDzp9HTRLceA+WFSQvMY1rLRzZnYL7jcUdr6vQ3iYxckp9n4j22+MIfz/qWWh19Taft+hFSredfQYigRmY0PVMKVSHmIJEPiC0zwg3V0wJLPtzasnN9abh0GID4TZeuxTGcsB0D1Fw1vYsg=; X-YMail-OSG: U8ySStIVM1nb69xw9GaTQzr5DQIoW2I27mSbdOb9zpKRGcUumniLaL14UumidYM5Rb53WPfx7PeQLGVxP27DFNBa56mppQSKJCNL Received: from [67.121.145.24] by web57102.mail.re3.yahoo.com via HTTP; Sun, 01 Apr 2007 06:59:36 PDT Date: Sun, 1 Apr 2007 06:59:36 -0700 (PDT) From: Abu Mushayeed Subject: max_fsm_pages To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1043029557-1175435976=:89112" Content-Transfer-Encoding: 8bit Message-ID: <718991.89112.qm@web57102.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=4.379 tagged_above=0 required=5 tests=AWL=1.389, BAYES_20=-0.74, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, DNS_FROM_RFC_WHOIS=1.447, HTML_30_40=0.374, HTML_MESSAGE=0.001 X-Spam-Level: **** X-Archive-Number: 200704/1 X-Sequence-Number: 25065 --0-1043029557-1175435976=:89112 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit PG DB: 8.1.3 12 DB in the cluster When I do a full vacuum of the database cluster, at the end I am getting the message as follows: psql:dba_task.sql:1: INFO: free space map contains 8033993 pages in 1023 relations DETAIL: A total of 8000000 page slots are in use (including overhead). 8201952 page slots are required to track all free space. Current limits are: 8000000 page slots, 32768 relations, using 49054 KB. psql:dba_task.sql:1: NOTICE: number of page slots needed (8201952) exceeds max_fsm_pages (8000000) HINT: Consider increasing the configuration parameter "max_fsm_pages" to a value over 8201952. My questions are: 1. With out increasing the max_fsm_pages, can I bring down the need for fsm_pages by deleting unnecessary tables? 2. As, the database grows the need for max_fsm_pages grows too, what is the best practice? 3. As a new postgres DBA, how should one manage this parameter? Thanks Abu Mushayeed --------------------------------- It's here! Your new message! Get new email alerts with the free Yahoo! Toolbar. --0-1043029557-1175435976=:89112 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
PG DB: 8.1.3
12 DB in the cluster
 
When I do a full vacuum of the database cluster, at the end I am getting the message as follows:
 
psql:dba_task.sql:1: INFO:  free space map contains 8033993 pages in 1023 relations
DETAIL:  A total of 8000000 page slots are in use (including overhead).
8201952 page slots are required to track all free space.
Current limits are:  8000000 page slots, 32768 relations, using 49054 KB.
psql:dba_task.sql:1: NOTICE:  number of page slots needed (8201952) exceeds max_fsm_pages (8000000)
HINT:  Consider increasing the configuration parameter "max_fsm_pages" to a value over 8201952.
 
My questions are:
 
1. With out increasing the max_fsm_pages, can I bring down the need for fsm_pages by deleting unnecessary tables?
2. As, the database grows the need for max_fsm_pages grows too, what is the best practice?
3. As a new postgres DBA, how should one manage this parameter?
 
Thanks
Abu Mushayeed


It's here! Your new message!
Get new email alerts with the free Yahoo! Toolbar. --0-1043029557-1175435976=:89112--