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%2457938420%2406ba8c60%24%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. For more options, visit https://groups.google.com/d/optout.
