In this post, sharing a small note on one of the internal architecture things of PostgreSQL. Each Table and Index has an FSM which used to keep track of available space in the relation. It stores all free space related information in an alongside primary relation and that relation starts with the file node number … Continue reading PostgreSQL: What is a Free Space Map (FSM)?