Menu
Is it possible to suspend index maintenance in MongoDB to improve insertion speed and turn on (or rebuild) indexes afterwards? According to documentation it looks like after ensureIndex() the index maintained during all subsequent inserts and updates.
366
No option to disable index in mongodb, either you can drop and recreate the index or wait for the insert/update to complete.
MongoDB automatically determines whether to create a multikey index if the indexed field contains an array value; you do not need to explicitly specify the multikey type.
Starting in MongoDB 5.2, you can use db. collection. dropIndexes() to drop existing indexes on the same collection even if there is a build in progress on another index.
Partial indexes only index the documents in a collection that meet a specified filter expression. By indexing a subset of the documents in a collection, partial indexes have lower storage requirements and reduced performance costs for index creation and maintenance.
Indexes are updated synchronously with the insert/update. So there's no way to "pause" this. If you're anticipating a large batch insert, you could drop the index, perform the insert and then rebuild the index. Of course, this has some implications:
125
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
