Thank you Mark, in your word “time based indexes”, is that means create one index every day? if I index my data in this way, i have to specify which index to search when create query in my java client, based on the “from” and “to”.
Sent from Surface From: Mark Walkom Sent: Friday, August 1, 2014 11:02 AM To: [email protected] If you're using time series data then it makes sense to use time based indexes. Regards, Mark Walkom Infrastructure Engineer Campaign Monitor email: [email protected] web: www.campaignmonitor.com On 1 August 2014 12:43, David Pilato <[email protected]> wrote: Well. I guess it depends on your query. What does it look like? -- David ;-) Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs Le 1 août 2014 à 04:14, "Wang Yong" <[email protected]> a écrit : Hi folks, I have an index storing lots of time serial data. The data are put into index by : curl -XPUT 'localhost:9200/testindex/action1/1?pretty' -d ' { "val": 23, "timestamp": 1406822400 }' And the only thing I search in this index is histogram facet in a very short time range, like “recent 5 min”. I found that the performance was pretty good at first. But when the index get bigger, the performance dropped to unacceptable. I found the IO maybe the bottleneck by checking the result of iostat. My question is, even I only facet in a very short time range, why the size of index has so big impact on the performance of such query? Do I have to use daily index, just like logstash? -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/00fd01cfad2e%2457938420%2406ba8c60%24%40gmail.com. For more options, visit https://groups.google.com/d/optout. -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/0D3FCF70-13F5-4E92-8407-47E907736F79%40pilato.fr. For more options, visit https://groups.google.com/d/optout. -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAEM624YEg4XVNGAN%2BL8P6QHKjFn_9JTqkJE7TtMHh8fPqZhFxg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout. -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/53db1a2f.8d5b460a.30e5.41d5%40mx.google.com. For more options, visit https://groups.google.com/d/optout.
