Hello,
I would like to ask for advice about our index that is built on the
principle of Parent Child,
Now a search word takes a very long time about 3 minutes.
Below is the index structure.
Our database (shown below the index schema) contains information about
purchases and reviews in different stores.
Parent contains meta data of purchase and the children contain comments
regarding a purchase and names of goods (products).
Important to note that the search will always be performed for only one
shop (for a particular store_id). Although we have only one single index,
no partitions so all stores are in this index
At the moment the query to find the parent whose children have the word
takes up to a few minutes .....
Information on cluster and index:
Number of documents 2.7 billion, the size of 360 gigs
9 shards, one replica (of 18)
6 physical nodes
Your help is highly appreciated
Vlad Feigin
The index structure is :
{
"Purchase": {
"mappings": {
"default": {
"dynamic": "false",
"_all": {
"enabled": false
},
"_ttl": {
"enabled": true,
"default": 34560000000
},
"_source": {
"enabled": false
},
"properties": {
}
},
"Parent": {
"dynamic": "false",
"_all": {
"enabled": false
},
"_ttl": {
"enabled": true,
"default": 34560000000
},
"properties": {
"store_id": {
"type": "string",
"index": "not_analyzed",
"store": true
},
"endTime": {
"type": "long",
"store": true
},
"startTime": {
"type": "long",
"store": true
},
"purchaseId": {
"type": "string",
"index": "not_analyzed",
"store": true
}
}
},
"comments": {
"dynamic": "false",
"_all": {
"enabled": false
},
"_parent": {
"type": "Parent"
},
"_routing": {
"required": true
},
"_ttl": {
"enabled": true,
"default": 34560000000
},
"_source": {
"enabled": false
},
"properties": {
"text": {
"type": "string"
}
}
},
"products": {
"dynamic": "false",
"_all": {
"enabled": false
},
"_parent": {
"type": "Parent"
},
"_routing": {
"required": true
},
"_ttl": {
"enabled": true,
"default": 34560000000
},
"_source": {
"enabled": false
},
"properties": {
"name": {
"type": "string"
}
}
}
}
}
}
--
This message may contain confidential and/or privileged information.
If you are not the addressee or authorized to receive this on behalf of the
addressee you must not use, copy, disclose or take action based on this
message or any information herein.
If you have received this message in error, please advise the sender
immediately by reply email and delete this message. Thank you.
--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/9cae55d5-c702-4e82-ad86-c90f674b8a6b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.