What is Fill Factor in PostgreSQL

15 · özkan pakdil · Feb. 18, 2025, 6:11 p.m.
Summary
This blog post explains the concept of 'Fill Factor' in PostgreSQL, detailing how it influences performance in updated tables by allowing a percentage of a data page to remain unfilled for future updates. It describes how to set fill factors for tables and indexes and includes queries for retrieving fill factors. The piece also highlights performance implications based on fill factor settings, which can be beneficial for developers working with PostgreSQL.