You can create one every hour if you want, daily is good. You may have to deal with that in the code however it makes management a lot easier.
Regards, Mark Walkom Infrastructure Engineer Campaign Monitor email: [email protected] web: www.campaignmonitor.com On 1 August 2014 14:35, Wang Yong <[email protected]> wrote: > 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 <[email protected]> > *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 >> <https://groups.google.com/d/msgid/elasticsearch/00fd01cfad2e$57938420$06ba8c60$%40gmail.com?utm_medium=email&utm_source=footer> >> . >> 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 >> <https://groups.google.com/d/msgid/elasticsearch/0D3FCF70-13F5-4E92-8407-47E907736F79%40pilato.fr?utm_medium=email&utm_source=footer> >> . >> >> 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 > <https://groups.google.com/d/msgid/elasticsearch/CAEM624YEg4XVNGAN%2BL8P6QHKjFn_9JTqkJE7TtMHh8fPqZhFxg%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > > 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 > <https://groups.google.com/d/msgid/elasticsearch/53db1a2f.8d5b460a.30e5.41d5%40mx.google.com?utm_medium=email&utm_source=footer> > . > > 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/CAEM624ZoiAOdaFoRaCXjUyKPe%3D1ah%2B_q79wA%2BDy8bkEDVL%2ByRw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
