[Tile-serving] [osm2pgsql] Investigate clustering on geohash (#87)
Paul Norman
notifications at github.com
Tue Nov 12 11:05:18 UTC 2013
Note: SQL was
```sql
SELECT AVG((SELECT COUNT(*) FROM (SELECT DISTINCT (ctid::text::point)[0] AS page FROM planet_osm_line WHERE ST_Buffer(point,0.0001) && way) AS s)) FROM (SELECT ST_SetSRID(ST_Point(-123.32+0.01*x, 49+0.01*y),4326) AS point FROM generate_series(0,64) x CROSS JOIN generate_series(0,40) y) AS points;
```
---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/87#issuecomment-28284917
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20131112/cf6690a9/attachment.html>
More information about the Tile-serving
mailing list