fillfactor in PostgreSQL controls how full table or index pages are. The lower the fillfactor, the better the performance on update-heavy tables. In this article, learn everything you need to know about fillfactor in PostgreSQL – from what it is, to exactly when (and how) you should adjust it.
PostgreSQL comes pre-configured with hundreds of various settings. We’ll never want to change (or are even aware of) most of them, but there is one you definitely should be familiar with: fillfactor.
First, some background. All database management systems (DBMS’) implement ways to avoid conflicts between users simultaneously modifying and accessing