Slow query performance


(Luke Wilson-Mawer) #1

Hi,

I'm trying to improve query performance. It takes an average of about 3
seconds for simple queries which don't even touch a nested document, and
it's sometimes longer.

curl
"http://searchbox:9200/global/user/_search?n=0&sort=influence:asc&q=user.name:Bill%20Smith"

Even without the sort it takes seconds. Here are the details of the cluster:

1.4TB index size.
210m documents that aren't nested (About 10kb each)
500m documents in total. (nested documents are small: 2-5 fields).
About 128 segments per node.
3 nodes, m2.4xlarge (-Xmx set to 40g, machine memory is 60g)
3 shards.
Index is on amazon EBS volumes.
Replication 0 (have tried replication 2 with only little improvement)

I don't see any noticeable spikes in CPU/memory etc. Any ideas how this
could be improved?

Kind regards,

Luke

--
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/204f6112-18ca-46fb-83b9-730579c8fedd%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


(Binh Ly-2) #2

If you are not concerned with relevance scores, you might want to use
filters exclusively. This article describes what filters are and how to use
them effectively:

--
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/a0353fd1-2a24-4a7e-8132-e98fcb5b3c22%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


(system) #3