Re: Indexing large table of coordinates with GiST

 On January 15, 2015 at 12:36:29 PM, Daniel Begin (jfd553@hotmail.com(mailto:jfd553@hotmail.com)) wrote:

> Paul, the nodes distribution is all over the world but mainly over inhabited areas. However, if I had to define a
limitof some sort, I would use the dateline. Concerning spatial queries, I will want to find nodes that are within the
boundaryof irregular polygons (stored in another table). Is querying on irregular polygons is compatible with
geohashing?


Well… yes you can, although the relative efficiency compared to r-tree will depend a bit on how the query polygons
interactwith the geohash split points. Also, if you’re planning to slam pretty large polygons through this process,
expectit to be kind of slow. You’ll want to do some sharding, to spread the problem out over multiple nodes. 
 

-- 
Paul Ramsey
http://cleverelephant.ca 
http://postgis.net