Our index has 3 primary shards. Previously, id was used for routing by default. Now we need to change to use another field as routing, and create a docuemnt based on this routing, but when we do update or delete operation by id, we don’t know what the routing is, we can’t find this document. Is there any good suggestions? Or is there a way to broadcast this operation without routing to all shards?
Thank you very much.
Please make your title shorter.
Why are you using routing for?
Or is there a way to broadcast this operation without routing to all shards?
You can do something like update by query and delete by query which will run a search + the update or delete operation. I'm not sure if this is super efficient though.
I know routing when searching, but I don’t know routing when searching documents by id.
Why are you using routing? How many primary shards do you have? What is the ratio between indexing and search requests?
I have a field, and I want to make the data of the same field to a shard so that the performance can be better. I now have three shared.There will be a little more search requests.
I have a field, and I want to make the data of the same field to a shard so that the performance can be better. I now have three shared.There will be a little more search requests.
What is the size of the whole index? In number of documents and size on disk?
The total number of index14.7GB. Index number is 129728679.
Adding routing does complicate things, especially when you do not know the value after initial indexing. Have you benchmarked and measured the impact routing has? Is it worth it?
If your load is mixed it may not be worth the extra work at indexing time.
I believe that only one shard might be enough to hold all the data. Something you need to test though but in that case you'll probably avoid complexity and still have a very good response time.
1 Like
Thank you very much. But our data will increase in the future.
I will carefully consider this issue, thank you very much.
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.