Skip to content

set fillfactor for tables where many records are frequently updated

Marcin requested to merge mi_speedup_updates_hive_posts_after_sync into develop

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

Merge request reports

Loading