Hello! I have a time series collection with a granularity of minutes and recently found that it takes over a second to delete even 10 minutes of data. I did some profiling and found that the Deletes do use indexes to fetch the time series buckets but the TS_MODIFY stage takes a couple of seconds. I’ve been trying to see why that could be and the only thing I could think of was that Mongo unpacks the bucket(s), rewrite the bucket without the removed data, and remakes the buckets. Is that accurate? I tried looking into the documentation to see if there’s any additional information or insight into this process but I couldn’t really find anything. Any info or help would be very much appreciated!
Skip to main content
New & Unread Topics
Topic | Replies | Views | Activity |
---|---|---|---|
Hashing the password with pre saving middleware | 2 | 444 | Dec 2024 |
Count Query data in a large collection | 2 | 247 | Aug 2024 |
Stress testing app which uses MongoDB | 4 | 84 | Dec 2024 |
Node js driver version conflicts with Mongo 3.6 | 2 | 2.1k | Nov 2024 |
Update Property of an Array Element in an Aggregration Pipeline | 8 | 88 | Feb 13 |