<br />If HOT gets into 8.3, we might need a GUC to set database wide heap<br />fillfactor to an appropriate value. The
onlyway to so today is compile<br />time value of DEFAULT_HEAP_FILLFACTOR. HOT works much<br />better if there is
atleastone tuple worth of free space in each block. <br />Otherwise atleast the first UPDATE in each block would be a
COLD<br/>update.<br /><br clear="all" />Should we consider adding such a GUC now ? I searched through<br />archives,
butdid not find any strong objection to doing so in the past. <br />But I might have missed something. Comments ?<br
/><br/>Thanks,<br />Pavan<br /><br />-- <br />Pavan Deolasee<br />EnterpriseDB <a
href="http://www.enterprisedb.com">http://www.enterprisedb.com</a>
