[OSM-dev] Postgres amazing spatial indices

[Andreas Kalsch]

To make it even faster: Can you scale Postgres indexes across serveral 
servers?

Andi

Am 28.07.10 09:48, schrieb 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
>
>
>
>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/dev
>
>