You are right that delete+insert gives quite some work to the database, but so does any workload which has a roughly constant-size working-set. If your dataset is not growing, it means that your writes are either overwrites or delete+insert. Both are challenging for the database, just in different ways. All that said, the database is designed to cope with this so such a workload on its own will not be a problem.
1 Like