deleteMany increases index size

Asked Apr 24 '23 at 01:49

Active Apr 24 '23 at 02:42

Viewed 36 times

I have a collection with 100,000 documents, with index totalling 80MB. Then I dropped all documents by running:

col.deleteMany({})

After the operation, the index size increased to 190.46MB.

What explains this?

EDITED:

And now it has settled at 110MB.

edited Apr 24 '23 at 02:42

asked Apr 24 '23 at 01:49

1

I am not sure how the space increased, but you can try compact command to release unused space. https://www.mongodb.com/docs/manual/reference/command/compact/ – Charchit Kapoor Apr 24 '23 at 04:42
Please take a backup before, if the data is crucial. – Charchit Kapoor Apr 24 '23 at 04:42

0 Answers0