Author's photo

Reclaiming Disk Space in PostgreSQL after DELETE operation

  • 736 words
  • 4 minutes read
  • 17 May 2023
Figure 1. Example of initial table with corresponding index
Figure 1. Example of initial table with corresponding index

The above is a simple table with a corresponding index that we are going to use to describe the data deletion flow using two methods: DELETE and TRUNCATE, and how those methods affect physical space after completion.