Re: Slow date filter query

2016-05-30 Thread Jay Potharaju
There are about 30 Million Docs and the index size is 75 GB. Using a full timestamp value when querying and not using NOW. The fq queries covers almost all the docs(20+ million) in the index. Thanks On Mon, May 30, 2016 at 8:17 PM, Erick Erickson wrote: > Oops, fat fingers. > > see: > searchhu

Re: Slow date filter query

2016-05-30 Thread Erick Erickson
Oops, fat fingers. see: searchhub.org/2012/02/23/date-math-now-and-filter-queries/ If you're not re-using the _same_ filter query, you'll be better off using fq={!cache=false}range_query Best, Erick On Mon, May 30, 2016 at 8:16 PM, Erick Erickson wrote: > That does seem long, but you haven't p

Re: Slow date filter query

2016-05-30 Thread Erick Erickson
That does seem long, but you haven't provided many details about the fields. Are there 100 docs in your index? 100M docs? 500M docs? Are you using NOW in appropriately? See: On Fri, May 27, 2016 at 1:32 PM, Jay Potharaju wrote: > Hi, > I am running filter query(range query) on date fields(high c

Slow date filter query

2016-05-27 Thread Jay Potharaju
Hi, I am running filter query(range query) on date fields(high cardinality) and the performance is really bad ...it takes about 2-5 seconds for it to come back with response. I am rebuilding the index to have docvalues & tdates instead of "date" field. But not sure if that will alleviate the proble