Brian, which one of them is osm_type "way" in placex? ST_LineSting? These are the geometry values that are leaking the memory...
2010/3/27 Brian Quinion <[email protected]>: > >> Do you know the answer of the last question above? > > It changes as it goes down the table, it's a right mixture. > > ST_LineString | 2 | 5398548 > ST_Point | | 20648939 > ST_MultiPolygon | | 6188 > ST_Polygon | | 8054680 > > > One thing you could try is indexing each geometry type in turn and > watch the memory usage. > _______________________________________________ Geocoding mailing list [email protected] http://lists.openstreetmap.org/listinfo/geocoding
