o even further, t… can look at them as DML (Data Manipulation Language) or DDL (Data Definition Language) approaches.
Deleting data using DML commands (e.g. DELETE FROM … WHERE …
) is a very expensive operation and it comes with a lot of overhead on your table.
On top of this, you need the VACUUM to kick in and reclaim that space back. If we want to go even further, the VACUUM only cleans up 180 million rows at a time. So, if you are…