I have some questions about the timeseries that where introduced with MongoDb5.0. I only found documentation about the limitations but no suggestion for a solution/workaround.
Is there any way to create uniqueness of _id fields inside the timeseries? On normal collection we could use a unique index I guess but thats not supported for timeseries. Current workaround is to make a find on _id and filter documents befor inserting. Is there any smarter / more efficent alternative for this?
Is there any way to delete timeseries data based on ts or _id that is NOT the TTL of the timeseries?
Delete many complains that it can only be used on “metadata” fields but in my understanding ts and _id should not be in the meta data because it makes the clustering of the underlaying data useless.
Currently we have one collection per “data measuring device (1.500+)”, with the timeseries data from different sub devices inside each collection. Is the idea behind the timeseries having all locations in one timeseries collection and that what is currently the collection name inside the meta field? Because we store other data in that collection that should not be deleted based on time but using 1.500 extra collections to make use of the TTL sounds not efficent. So any idea how to delete only some data inside a timesries collection based on time or should we just use the normal collection/remodell our data?
Hope someone has a better understanding of this and can give me some input.