Re: [postgis-users] creating topology data is slow

2015-06-03 Thread Lars Aksel Opsahl
Yes that was the first problem we we got and we got dead locks so we where not able to finish the job at all. If we get a topology exception we roll back the all the transactions to avoid the problem and having invalid topology data stored in the database. The way avoid this problem was to

Re: [postgis-users] memory usage of st_clip/st_intersection in a session

2015-06-03 Thread Rémi Cura
Hey, could it be that in the first case you perform everything into one transaction? Chers, remic Le 2 juin 2015 20:52, Bborie Park dustym...@gmail.com a écrit : Based upon your description, I can't guess as to the cause of the memory leak(?). Can you post the query and provide some

[postgis-users] postgis raster data in JavaEE

2015-06-03 Thread Ahmet Temiz
hello What are the ways to retrieve postgis raster data into JavaEE and display it using java ? Can you provide hints ? ​kind regards​ -- Ahmet Temiz Jeoloji Müh. Afet ve Acil Durum Yönetimi Başkanlığı Bilgi İşlem Dairesi Başkanlığı-CBS Grubu Ahmet Temiz

Re: [postgis-users] postgis raster data in JavaEE

2015-06-03 Thread Rémi Cura
Hey, http://gdal.org/java/ Cheers, Rémi-C 2015-06-03 14:08 GMT+02:00 Ahmet Temiz ahmettemi...@gmail.com: hello What are the ways to retrieve postgis raster data into JavaEE and display it using java ? Can you provide hints ? ​kind regards​ -- Ahmet Temiz Jeoloji Müh. Afet ve Acil

Re: [postgis-users] creating topology data is slow

2015-06-03 Thread Lars Aksel Opsahl
We are working quite big datasets (about 1 billion points and 20 million lines) that we convert from simple feature to topology. I ran a test yesterday and we added these 20 million lines in about 9 hours with attached attributes. This means heavy parallel pressing and grid usage on a fast