@mackuba.eu I think Pg does deletes faster because it only flags a row as deleted and moves on. It pays a penalty for this by having to do the work later during vacuum, and having some lookups slower because it doesn’t know if a record still exists. But the vacuum is done async, so doesn’t slow down main proc.
Replying to: