set fillfactor for tables where many records are frequently updated
Changed the fillfactor from default of 100% to 70% to reserve additional space on data pages for subsequent copies of updated records. This prevents postgresql from always adding a new row version to the last (active) page and thereby creating data fragmentation, which causes slow queries. When the table is badly fragmented, we have seen execution time differences starting from 20s up to 130s.
Edited by Dan Notestein