141 reputation
4
bio website consulting-en.nraynaud.com
location Montpellier, France
age 34
visits member for 2 years, 2 months
seen Sep 4 '13 at 9:10

Oct
27
awarded  Supporter
Jun
3
comment How to speed up space partitioning in postgis?
hello, here is the result : "POSTGIS="1.5.3" GEOS="3.3.2-CAPI-1.7.2" PROJ="Rel. 4.8.0, 6 March 2012" LIBXML="2.7.3" USE_STATS". I could not find any relevant addition to union in GEOS recently. I found one speedup in polygon unions, but I'm not merging polygons, and this speedup seems controversial. I absolutely don't want do union my polygons as I have to add values for overlapping polygons.
May
22
comment How to speed up space partitioning in postgis?
by collecting the linework and doing an union with an empty geometry, I can do it in 800s : st_union(st_collect(geom), st_setsrid(geomfromtext('POINT EMPTY'), 900913)) that's almost 20 times slower than the ESRI stuff.
May
22
comment How to speed up space partitioning in postgis?
I'm not really fan of mailing lists, moreover, it might also be an GEOS problem, who might complain about JTS, well, I prefer keeping the problem open.
May
22
awarded  Student
May
22
awarded  Editor
May
22
revised How to speed up space partitioning in postgis?
added numbers
May
21
asked How to speed up space partitioning in postgis?
May
21
awarded  Autobiographer