July 28, 2023

PostgreSQL: Vacuum, Vacuum Analyze and Autovacuum

When we delete or update a record in postgreSql, it hides the old data. These datas are called dead rows. PostgreSQL doesn’t physically remove the old row from the table but puts a “marker” on it so that queries don’t return that row. A vacuum is used for recovering space occupied by “dead tuples” in […]