Timeline for memory issue when trying to buffer/union large dataset using postgis
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 31, 2012 at 14:16 | comment | added | Jahfet | Thanks Paul. Your solution worked (almost) perfectly. It is a bit slow to run on my server (I think I still have work to do to optimise memory usage, it now never ramps up!) but it does the job! I had to remove the last step (groupedfinal) because for some reason it crashes (Error message: GEOSUnaryUnion: St9bad_alloc - even though I call ST_Union not ST_UnaryUnion, and even if I ST_Dump() the multipolygons before the final union to simplify the geometries). However I managed to run that step separately in arcgis so that is not a big issue. | |
| Aug 31, 2012 at 14:04 | vote | accept | Jahfet | ||
| Aug 24, 2012 at 21:07 | comment | added | Paul Ramsey | Just wrap in a call to transform, ST_GeoHash(ST_Transform(geom, 4326)) | |
| Aug 24, 2012 at 11:16 | comment | added | Jahfet | Thanks for your help. I do have 1 attribute I could use in a group by clause, but I suspect it won't help much (only 2 values in the field, and the split is 90% / 10%). If spliting the multipolygon in individual polygons using ST_Dump or similar would help I can definitely do it, but from what I can tell this would happen after the massive multigeometry is created anyway so not sure it would help? also, my geometries are not in lat-long, so if I want to use geohash I believe I need to convert the coordinates first... is there an alternative? | |
| Aug 22, 2012 at 0:15 | history | answered | Paul Ramsey | CC BY-SA 3.0 |