I am trying to perform some benchmark testing on ES to see if I can find
all the points that fall within a polygon AND beat PostGIS. I am having
some trouble getting my query to work and would like to bounce some of it
off this list. Here is how I am running my tests.
- Load all of the Geonames data in to ES. There are 7.8 million points
all over the world so I figure this would be a good use case. The schema
looks like this. http://pastebin.com/GbVDjEMi
- Next, I extracted all the polygons for each country in the world. You
can find the data here:
- Finally, I build up my query like this. http://pastebin.com/dMFeYeSJ The
problem is that nothing happens and I don't know if it's because the query
is wrong or if ES just can't handle that many points.
Any help on this would be greatly appreciated. I will post the full
workflow and results once I am done with this.