This mostly applies to almost any database.

Deletes are Writes and Writes are resource intensive. This is more prominent on databases like Elastic Search.

When I was tasked to delete millions of (old) documents, it overloaded the cluster and almost brought it down. Only scalable solution was to split the index and drop the whole index.