# Are there any performance or inconsistency issues when using Permanently Delete?
**URL:** https://meta.discourse.org/t/are-there-any-performance-or-inconsistency-issues-when-using-permanently-delete/271398
**Category:** Support
**Tags:** permanently-delete
**Created:** [November 17, 2021, 1:37pm UTC](https://meta.discourse.org/t/are-there-any-performance-or-inconsistency-issues-when-using-permanently-delete/271398 "2021-11-17T13:37:05Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@Simon\_Manning](https://meta.discourse.org/u/Simon_Manning)
#### Post date: [November 17, 2021, 1:37pm UTC](https://meta.discourse.org/t/are-there-any-performance-or-inconsistency-issues-when-using-permanently-delete/271398/1 "2021-11-17T13:37:05Z")
> [@Introducing permanently delete post functionality](https://meta.discourse.org/t/introducing-permanently-delete-post-functionality/207109/1):
>
> because of how dangerous it can be
Are there dangers such as reduced database performance, inconsistencies, anything else? Or is not being able to recover the permanently deleted posts the only danger?
---
### Author:  [@nbianca](https://meta.discourse.org/u/nbianca)
#### Post date: [November 17, 2021, 5:02pm UTC](https://meta.discourse.org/t/are-there-any-performance-or-inconsistency-issues-when-using-permanently-delete/271398/2 "2021-11-17T17:02:00Z")
> [@Simon\_Manning](#):
>
> Are there dangers such as reduced database performance, inconsistencies, anything else? Or is not being able to recover the permanently deleted posts the only danger?
It is just that once a post is deleted it is gone forever and it cannot be recovered. There are no performance concerns.
---
### Author:  [@mentalstring](https://meta.discourse.org/u/mentalstring)
#### Post date: [November 17, 2021, 6:34pm UTC](https://meta.discourse.org/t/are-there-any-performance-or-inconsistency-issues-when-using-permanently-delete/271398/3 "2021-11-17T18:34:59Z")
I actually have the opposite question: isn’t there reduced performance from Discourse from only soft deleting posts instead always permanently deleting them? There must be some burden acumulated after some years for some forums. Is it done this way to keep statistics for each account even when posts/topics are removed?
---
### Author:  [@Falco](https://meta.discourse.org/u/Falco)
#### Post date: [November 17, 2021, 6:47pm UTC](https://meta.discourse.org/t/are-there-any-performance-or-inconsistency-issues-when-using-permanently-delete/271398/4 "2021-11-17T18:47:36Z")
> [@mentalstring](#):
>
> I actually have the opposite question: isn’t there reduced performance from Discourse from only soft deleting posts instead always permanently deleting them?
Not really. BTree indexes mean we can search in `O(log n)` for posts and topics, so there is a sub-linear cost growth.
In the largest Discourse instances out there, post quantity never were the performance bottleneck in production. That said we keep an eye on it and we can always come back and refactor it if needed.
---
### Author:  [@nbianca](https://meta.discourse.org/u/nbianca)
#### Post date: [November 17, 2021, 7:38pm UTC](https://meta.discourse.org/t/are-there-any-performance-or-inconsistency-issues-when-using-permanently-delete/271398/5 "2021-11-17T19:38:35Z")
In short, no.
First of all, I believe that most communities have many more visible posts than deleted posts. For example, here on Meta the total amount of posts is 1,015,386 and only 81,480 of these are deleted. That is less than 10%. Probably the total amount of deleted data is less than 100MB of data.
As Falco said, the performance impact of storing and indexing more data is negligible. Database systems are optimized to hold a lot more data than one can imagine and even the most simple configurations can hold thousands of thousands of data points without breaking a sweat.
Maybe this is not the best comparison in the world, but can you notice your PC getting slower as you store more files? Most probably no and the file system is some kind of database system too. 🙂
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [July 12, 2023, 12:40pm UTC](https://meta.discourse.org/t/are-there-any-performance-or-inconsistency-issues-when-using-permanently-delete/271398/6 "2023-07-12T12:40:57Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.