[OSM-dev] Postgres amazing spatial indices

[Juan Lucas Domínguez Rubio]

After exporting the OSM planet to Postgres, I get -among others- a 43 GB table with lines, and this random spatial query only takes one second to respond :-D

SELECT name FROM p100618_line WHERE ST_Intersects(GeometryFromText('POLYGON((-111.296 47.503,-111.296 47.51,-111.27 47.51,-111.27 47.503,-111.296 47.503))', 4326), way);

Hooray for spatial indices!

Regards,
Juan Lucas