fsm and vacuum

<div class="WordSection1"><p class="MsoNormal">We’re new to Greenplum, based on PG (8.2.13).  we weren’t advised to
increasethe max_fsm_relations switch as our db has grown.<p class="MsoNormal">Currently we’re nearly 14k tables/indexes
andthe switch is set to 1000.<p class="MsoNormal">We’ve got it updated now, but wondering about the effect &
recovery.<pclass="MsoNormal"> <p class="MsoNormal">We’ve regularly been reloading tables with CTAS.<p
class="MsoNormal">I’vedone some experiments and want to confirm my understanding.<p class="MsoNormal"> <p
class="MsoNormal">1.Vacuum full only compacted the  oldest? tables (reducing pages from 109 to 5)<p
class="MsoNormal">2. vacuum full frees pages, but doesn’t reduce the file size (newer tables).  Table needed to be
recreatedto reduce size<p class="MsoNormal"> <p class="MsoNormal">I’ve searched the archives and haven’t found what I’m
lookingfor.  I hope someone would just dash off a simple explanation.<p class="MsoNormal"> <p class="MsoNormal">1. 
whenare relations added to the fsm? (at create, or some other time)<p class="MsoNormal">2.  will vacuum (full) add a
relationto the fsm - ?  <p class="MsoNormal">3.  if bloated table is vacuum full’d,  will the free space pages be
use?<pclass="MsoNormal"> <p class="MsoNormal">My assumptions are:<p class="MsoNormal">1. relation added to fsm list at
createtime.<p class="MsoNormal">2. fsm_pages keep track of free space for the relations being tracked in the
fsm_relationlist<p class="MsoNormal">3. table recreate is the only way to have a relation tracked.<p
class="MsoNormal"> <pclass="MsoNormal">Thanks in advance.<p class="MsoNormal"> <p class="MsoNormal"> <p
class="MsoNormal"> <pclass="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Doug
Little</span></b><pclass="MsoNormal"><b><span style="font-size:12.0pt"> </span></b><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial","sans-serif"">Sr.Data Warehouse Architect | Enterprise Data Management |
OrbitzWorldwide </span><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">500 W.
Madison,Suite 1000  Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164 | Cell 847-997-5741</span><span
style="font-size:12.0pt;font-family:"TimesNew Roman","serif""></span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Arial","sans-serif""><ahref="mailto:Douglas.Little@orbitz.com"
title="mailto:dlittle@orbitz.com"><b><spanstyle="color:blue">Douglas.Little@orbitz.com</span></b></a></span><b><u><span
style="font-size:13.5pt;font-family:"TimesNew Roman","serif";color:blue"></span></u></b><p class="MsoNormal"> <img
alt="cid:image001.jpg@01CABEC8.D4980670"border="0" height="61" id="Picture_x0020_1"
src="cid:image001.jpg@01CB922D.0A2B3AE0"width="83" />  <a href="http://www.orbitz.com/"
title="http://www.orbitz.com/"><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:blue">orbitz.com</span></a><span
style="color:blue">|</span><a href="http://www.ebookers.com/" title="http://www.ebookers.com/"><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:blue">ebookers.com</span></a><span
style="color:blue">|</span><a href="http://www.hotelclub.com/" title="http://www.hotelclub.com/"><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:blue">hotelclub.com</span></a><span
style="color:blue">|</span><a href="http://www.cheaptickets.com/" title="http://www.cheaptickets.com/"><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:blue">cheaptickets.com</span></a><span
style="color:blue">|</span><a href="http://www.ratestogo.com/" title="http://www.ratestogo.com/"><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:blue">ratestogo.com</span></a><spanstyle="color:blue">
|</span><a href="http://www.asiahotels.com/" title="http://www.asiahotels.com/"><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:blue">asiahotels.com</span></a><p
class="MsoNormal"> </div>