GUC for default heap fillfactor
От | Pavan Deolasee |
---|---|
Тема | GUC for default heap fillfactor |
Дата | |
Msg-id | 2e78013d0708080535o6ed0919duc85edd0f1d63ac15@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: GUC for default heap fillfactor
Re: GUC for default heap fillfactor Re: GUC for default heap fillfactor |
Список | pgsql-hackers |
<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>
В списке pgsql-hackers по дате отправления: